Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bansefi01
Contributor II
Contributor II

Count different

I have a table:

StateCountyBranch localtion
OaxacaJuchitanJuchitan 1
OaxacaJuchitanJuchitan B
ChiapasTuxtlaTuxtal 1
MexicoEcatepecEcatepec 1
Mexico EcatepecMercado
MexicoEcatepecAutopista

How can I count in a KPI all the counties where I have coverage (3) instead of a =count (County) will show 6?

1 Solution

Accepted Solutions
its_anandrjs

In any text box Object write

=Count(Distinct County)

View solution in original post

2 Replies
sunny_talwar

May be add DISTINCT...

Count(DISTINCT County)

its_anandrjs

In any text box Object write

=Count(Distinct County)