topic Re: select rows where value is not exist in App Development

select rows where value is not exist

valeriasakulskaya — Thu, 21 Jan 2021 12:00:08 GMT

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.

Re: select rows where value is not exist

GaryGiles — Thu, 21 Jan 2021 12:44:22 GMT

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.

Re: select rows where value is not exist

valeriasakulskaya — Thu, 21 Jan 2021 12:59:37 GMT

Thanks, it really helped