topic Re: Set Analysis - Uniques in Qlik Automate

Set Analysis - Uniques

karolbags — Sat, 03 Jun 2023 06:31:53 GMT

I have a set analysis formula counting Sales from “Germany” as follows:

(Count({<[Country]={‘Germany}>} Sales))

I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

How might I go about removing all duplicates of a third column / submissions column?

TIA!

Vegar — Sat, 03 Jun 2023 06:56:41 GMT

What if you start counting unique Submissions instead? Like this:

Count({<[Country]={'Germany'}>} distinct Submissions)

BrunPierre — Sat, 03 Jun 2023 07:09:54 GMT

Hi, From what I understand, perhaps this?

Count(DISTINCT If(Country='Germany' and Aggr(Count(DISTINCT Submissions),Country)=1,Sales,Null()))