Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks, it really helped