Qlik Community

Qlik Sense App Development

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

MVP
MVP

Re: Is it known behaviour?

So you are counting a field that is a key linking two or more tables?

You shouldn't count a key field (at least without a DISTINCT qualifier), the result is not deterministic as Qlik does not know which table records need to be scanned.

Highlighted
MVP
MVP

Re: Is it known behaviour?

It's also described here by Henric:

Count or Count distinct?

Not applicable

Re: Is it known behaviour?

Without distinct. I looked for duplicates and my id is also business number. I prepared technical key, hided it and now it is better Smiley Wink

tomasz_tru
Valued Contributor

Re: Is it known behaviour?

Better or as expected? So it was count on key field?