Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
cm
Not applicable

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
Not applicable

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
OmarBenSalem
Not applicable

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
Not applicable

Re: Count of Distinct When Two Conditions met

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

kaanerisen
Not applicable

Re: Count of Distinct When Two Conditions met

Hi,

Expression should be like:

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

Hope it helps..