https://community.qlik.com/t5/Catalog-and-Lineage/Set-Analysis-Uniques/m-p/2421497#M1250 <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> Wed, 21 Feb 2024 06:18:30 GMT ribak31 2024-02-21T06:18:30Z https://community.qlik.com/t5/Catalog-and-Lineage/Set-Analysis-Uniques/m-p/2421497#M1250 <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> Wed, 21 Feb 2024 06:18:30 GMT https://community.qlik.com/t5/Catalog-and-Lineage/Set-Analysis-Uniques/m-p/2421497#M1250 ribak31 2024-02-21T06:18:30Z https://community.qlik.com/t5/Catalog-and-Lineage/Set-Analysis-Uniques/m-p/2421656#M1251 <P>Perhaps you can count Submissions? Count({&lt;[Country]={‘Germany}&gt;} distinct Submissions) or perhaps Count({&lt;[Country]={‘Germany}, Sales={"&gt;0"}&gt;} distinct Submissions)</P> Wed, 21 Feb 2024 10:50:36 GMT https://community.qlik.com/t5/Catalog-and-Lineage/Set-Analysis-Uniques/m-p/2421656#M1251 henrikalmen 2024-02-21T10:50:36Z