Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chandrest
Contributor
Contributor

Set Analysis - Uniques

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!

Labels (2)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Hi, perhaps this.

=Count(DISTINCT {<[Country]={'Germany'}, Submissions= {"=Count(Submissions) = 1"}>} Sales)