Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
bansefi01
New Contributor

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

Re: Count different

In any text box Object write

=Count(Distinct County)

2 Replies
MVP
MVP

Re: Count different

May be add DISTINCT...

Count(DISTINCT County)

Re: Count different

In any text box Object write

=Count(Distinct County)