Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
is this similar to https://community.qlik.com/t5/App-Development/How-to-exclude-one-data-set-from-another/td-p/2496060
?
@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.