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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
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.