https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2497313#M1226301 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121051">@QFabian</a>&nbsp;Yes. Actually this topic my be deleted&nbsp; because there is an answer on the linked one. But I see no option to delete it.&nbsp;</P> Wed, 11 Dec 2024 09:09:22 GMT Peony 2024-12-11T09:09:22Z https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2496059#M1226285 <P>Hi All. <BR />Could you please give me a hint how to calculate how may Items from period 1 don't have values in period 2?<BR /><BR />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)&gt;0 and Len(Period2)&lt;1,1). <BR /><BR />Maybe exist something like&nbsp;Count({&lt;Period1-=Period2&gt;}Item)? Or something other solution that allows to take one data set and exclude from it all items that exists in other data set?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Peony_2-1733339091383.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/175205i8EFD2F81EAD2CF0B/image-size/medium?v=v2&amp;px=400" role="button" title="Peony_2-1733339091383.png" alt="Peony_2-1733339091383.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Peony_0-1733338354615.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/175203iBC1ECE3630F013AD/image-size/medium?v=v2&amp;px=400" role="button" title="Peony_0-1733338354615.png" alt="Peony_0-1733338354615.png" /></span></P> <P>&nbsp;</P> Wed, 04 Dec 2024 19:09:01 GMT https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2496059#M1226285 Peony 2024-12-04T19:09:01Z https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2496076#M1226286 <P>is this similar to&nbsp;<A href="https://community.qlik.com/t5/App-Development/How-to-exclude-one-data-set-from-another/td-p/2496060" target="_blank">https://community.qlik.com/t5/App-Development/How-to-exclude-one-data-set-from-another/td-p/2496060</A></P> <P>?</P> Wed, 04 Dec 2024 20:28:23 GMT https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2496076#M1226286 QFabian 2024-12-04T20:28:23Z https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2497313#M1226301 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121051">@QFabian</a>&nbsp;Yes. Actually this topic my be deleted&nbsp; because there is an answer on the linked one. But I see no option to delete it.&nbsp;</P> Wed, 11 Dec 2024 09:09:22 GMT https://community.qlik.com/t5/QlikView/Excluding-one-data-set-from-another/m-p/2497313#M1226301 Peony 2024-12-11T09:09:22Z