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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

 

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.