Reputation: 11

Qlikview how to get all excluded values on qlikview

I have two columns on Qlikview table: date and full name. All people work on some dates.

If I choose a date, it shows me a list of people who work on that date. I need to make a table of all the people that do not work on that date.

I have tried to make a page trigger to select unchecked but it doesn't help me.

Upvotes: 1

Answers (3)

Reputation: 948

Try to use element function E() which represent the excluded set.

sum({$<Dim1 = E({$})>} Expression1)

In your case Dim1 would be the Date dimension.

//Micke

Upvotes: 1

Reputation: 76

Select the date you want -> Right click on the date's list box and do 'select excluded'

Upvotes: 1

Reputation: 15071

Click on the date you want.

Right click on it.

Select Excluded.

Upvotes: 0