topic Re: Count Distinct Qlik Sense in App Development

Count Distinct Qlik Sense

Tue, 28 Jun 2016 07:27:11 GMT

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.

Tue, 28 Jun 2016 08:05:12 GMT

count( distinct [Invoice Nr.])

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

Regards,

Michael

MK_QSL — Tue, 28 Jun 2016 09:00:45 GMT

It's a case sensitive also...

check you have exact same name and spaces..

[Invoice Nr.]

Chanty4u — Tue, 28 Jun 2016 09:01:25 GMT

exp is ok

= Count(distinct [Invoice Nr.])

share sample app