Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

msawyercke
New Contributor III

Question about count function (should be easy)

When I use a simple count function on the following dates, why does the KPI total "20", instead of 25?  I feel like I skipped Kindergarten or something...

 

4/30/12
4/30/13
4/30/13
4/30/14
4/30/14
4/30/14
4/30/15
4/30/15
4/30/15
4/30/15
4/30/16
4/30/16
4/30/16
4/30/17
4/30/17
4/30/17
4/30/18
4/30/18
4/30/18
4/30/19
4/30/19
4/30/19
4/30/20
4/30/20
4/30/20

I apologize if this is posted in the wrong Forum category - Thanks!

3 Replies

Re: Question about count function (should be easy)

Is this a key field connecting two tables? If it is then check this following blog: Count or Count distinct?

Capture.PNG

msawyercke
New Contributor III

Re: Question about count function (should be easy)

Will do, Sunny - thanks for the quick response! 

msawyercke
New Contributor III

Re: Question about count function (should be easy)

By the way, the field is not connecting 2 tables...but I will check into your link anyway...

Community Browser