select rows where value is not exist

[valeriasakulskaya]

Hello. 

There was a problem creating a correct set analysis.
It is necessary to select all tasks that do not have a serial number 1.
for example
task  number
1            1
1            2
2            2
2            3
Correct answer 2

Thank you for any help.

[GaryGiles · Accepted solution]

To simply create a list of tasks in a dimension field that don't have a row with a number 1, try:

aggr(only({$<task-=p({<number={1}>} task)>}task), task)

(you will want to uncheck "include null values" for the dimension.

The key component is the set analysis expression "task-=p({<number={1}>} task)".  It tells Qlik to not include tasks that have number of 1.  You may need to rewrite it as "task-=p({1<number={1}>} task)" if you there other filters that might affect the selection of tasks.

[valeriasakulskaya]

Thanks, it really helped