https://community.qlik.com/t5/Data-Movement-Streaming/Set-Analysis-Uniques/m-p/2109246#M1377 <DIV class="mb-sm mb-xs px-md xs:px-0"> <DIV id="t3_m5v25g-post-rtjson-content" class="text-neutral-content md max-h-[253px] overflow-hidden s:max-h-[318px] m:max-h-[337px] l:max-h-[352px] xl:max-h-[452px] text-14"> <P>I have a set analysis formula counting Sales from “Germany” as follows:</P> <P>(Count({&lt;[Country]={‘Germany}&gt;} Sales))</P> <P>I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.</P> <P>How might I go about removing all duplicates of a third column / submissions column?</P> <P>TIA!</P> </DIV> </DIV> Wed, 19 Mar 2025 23:02:17 GMT chandrest 2025-03-19T23:02:17Z https://community.qlik.com/t5/Data-Movement-Streaming/Set-Analysis-Uniques/m-p/2109246#M1377 <DIV class="mb-sm mb-xs px-md xs:px-0"> <DIV id="t3_m5v25g-post-rtjson-content" class="text-neutral-content md max-h-[253px] overflow-hidden s:max-h-[318px] m:max-h-[337px] l:max-h-[352px] xl:max-h-[452px] text-14"> <P>I have a set analysis formula counting Sales from “Germany” as follows:</P> <P>(Count({&lt;[Country]={‘Germany}&gt;} Sales))</P> <P>I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.</P> <P>How might I go about removing all duplicates of a third column / submissions column?</P> <P>TIA!</P> </DIV> </DIV> Wed, 19 Mar 2025 23:02:17 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Set-Analysis-Uniques/m-p/2109246#M1377 chandrest 2025-03-19T23:02:17Z https://community.qlik.com/t5/Data-Movement-Streaming/Set-Analysis-Uniques/m-p/2109284#M1378 <P>Hi, perhaps this.</P> <P>=Count(DISTINCT {&lt;[Country]={'Germany'}, Submissions= {"=Count(Submissions) = 1"}&gt;} Sales)</P> Thu, 24 Aug 2023 07:04:12 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Set-Analysis-Uniques/m-p/2109284#M1378 BrunPierre 2023-08-24T07:04:12Z