Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
cm
New Contributor

Count of Distinct When Two Conditions met

Friends,

See the attached Excel -  super small representation of my data. My task is to get a COUNT of DISTINCT report #s (Column A), filtered by category (Column B) and Topic (Column C).

For example, using the attached, I'm trying to get a count of unique report #s in category A on topic X. Answer should be 3.
Please help. I'm so novice.

 

Thanks.

1 Solution

Accepted Solutions
kaanerisen
Contributor III

Re: Count of Distinct When Two Conditions met

Hi,

Expression should be like:

count({<CATEGORY={'A'},TOPIC={'X'}>}distinct REPORT)

Hope it helps..

3 Replies
Partner
Partner

Re: Count of Distinct When Two Conditions met

Use a bar chart, or a pivot table or a table or any chart u want:

as dimension :

1)Category

2) Topic

a measure:

count(distinct Report)

cm
New Contributor

Re: Count of Distinct When Two Conditions met

THanks! What would the expression look like in set analysis?

kaanerisen
Contributor III

Re: Count of Distinct When Two Conditions met

Hi,

Expression should be like:

count({<CATEGORY={'A'},TOPIC={'X'}>}distinct REPORT)

Hope it helps..