Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ipsitasyngenta
Contributor II
Contributor II

Count distinct between two fields.

Hello Everyone,

Need an urgent help.

Say I have two fields like Location and Attended_PeopleStatus where location field will have duplicate values.

Now I want the count of distinct status according to Region.

LocationAttended_PeopleStatus
A0
A0
B0
C0
C0
C0
C0
D1
D1
E1
F1
F1
F1
G1

Output Count of Attended_PeopleStatus should be:

0 - 3

1 - 4

Can anyone please advice how can i achieve this.

Thanks,

Ipsita

1 Reply
sunny_talwar

May be like this

Dimension

Attended_PeopleStatus

Expression

Count(DISTINCT Location)