Count Distinct Qlik Sense

[#1]

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.

[#2]

count( distinct [Invoice Nr.])

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

Regards,

Michael

[MK_QSL]

It's a case sensitive also...

check you have exact same name and spaces..

[Invoice Nr.]

[Chanty4u]

exp is  ok

= Count(distinct [Invoice Nr.])

share sample app