Qlik Community

Qlik Sense App Development

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

Not applicable

Count Distinct Qlik Sense

Dear All,

I sure it is trivial for an advanced user. However, I dont manage to use the count distinct formula correctly.

I type: Count(distinct[Invoice Nr.])

I only get "-" as an answer, although I have several hounderts of invoice numbers.

What am I doing wrong?

Thanks much in advance.

3 Replies
Not applicable

Re: Count Distinct Qlik Sense

count( distinct [Invoice Nr.])

The space is important, though the reason for this I do not know.



Re: Count Distinct Qlik Sense

It's a case sensitive also...

check you have exact same name and spaces..

[Invoice Nr.]

Esteemed Contributor III

Re: Count Distinct Qlik Sense

exp is  ok

= Count(distinct [Invoice Nr.])

share sample app