Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

Excluding one data set from another

Hi All.
Could you please give me a hint how to calculate how may Items from period 1 don't have values in period 2?

This should be 3 as an count result (Item2, Item3, Item6). But is there any option to calculate this not using If statement I use currently Sum(If( Len(Period1)>0 and Len(Period2)<1,1).

Maybe exist something like Count({<Period1-=Period2>}Item)? Or something other solution that allows to take one data set and exclude from it all items that exists in other data set?

Peony_2-1733339091383.png

 

Peony_0-1733338354615.png

 

Labels (3)
2 Replies
QFabian
MVP
MVP

is this similar to https://community.qlik.com/t5/App-Development/How-to-exclude-one-data-set-from-another/td-p/2496060

?

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
Peony
Creator III
Creator III
Author

@QFabian Yes. Actually this topic my be deleted  because there is an answer on the linked one. But I see no option to delete it.