Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
valeriasakulskaya
Contributor
Contributor

select rows where value is not exist

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.

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

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.

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

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.

View solution in original post

valeriasakulskaya
Contributor
Contributor
Author

Thanks, it really helped