Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

how to get all excluded values from a table

hello.

I have two columns on Qlikview table: date and full name.

All people work on some dates.

If i choose a date, it shows my a list of people that works 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.

please help.

1 Solution

Accepted Solutions

Re: how to get all excluded values from a table

Seems to be working in the attached sample:

Capture.PNG

6 Replies

Re: how to get all excluded values from a table

May be try this in your set analysis:

Concat{1<[full name] = e([full name])>} [full name], ', ')

Employee
Employee

Re: how to get all excluded values from a table

The best way is to first select the date, then right-click on the list box with employee name and Select Excluded.

See Finding NULL

HIC

Not applicable

Re: how to get all excluded values from a table

i did try this in a chart where the dimention was full name and it did not accept this line

Re: how to get all excluded values from a table

Seems to be working in the attached sample:

Capture.PNG

Not applicable

Re: how to get all excluded values from a table

thanks a lot  Sunny

MVP
MVP

Re: how to get all excluded values from a table

If the above suggestions do not work for you, I suggest that you post a representative sample qvw for more detailed help.

Community Browser