topic Use of count in Management & Governance

Use of count

Anonymous — Wed, 25 Jan 2017 17:11:38 GMT

Hello

New user of Qlik, I'm exercising ...

My file includes "categories" of products ...

In order to identify how many categories I buy from my supplier I used the function count.

The result gives me the number of command lines that include this category but not the number of categories ordered.

Could you help me solve this problem?

Thank you

Gysbert_Wassenaar — Wed, 25 Jan 2017 18:13:36 GMT

Perhaps you need to use count(distinct ...something...) instead of count(...something...)

Anonymous — Thu, 26 Jan 2017 08:32:26 GMT

Absolutely !

Thanks much

Beautiful day

oknotsen — Thu, 26 Jan 2017 14:08:49 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .