Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asinameli
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 (3)
1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

If you are counting distinct Submissions do you need to use Sales?

Maybe;

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

Cheers,

Chris.