Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense - Count Distinct? Proper Syntax when using Dimension Expression Builder

Count Distinct?  - Syntax for Qlik Sense? 


I want to do a distinct count of how many different subcategories there are in our parts catalog.  W


hat Syntax do I use to do a distinct count?

1 Solution

Accepted Solutions

Re: Qlik Sense - Count Distinct? Proper Syntax when using Dimension Expression Builder

May be this:

Count(DISTINCT subcategories)

3 Replies

Re: Qlik Sense - Count Distinct? Proper Syntax when using Dimension Expression Builder

May be this:

Count(DISTINCT subcategories)

Not applicable

Re: Qlik Sense - Count Distinct? Proper Syntax when using Dimension Expression Builder

Thank you Sunny, appreciate it.  Would you happen to have a list of sytax sitting around anywhere?  There is not simple way to get good examples for this kind of thing.

Re: Qlik Sense - Count Distinct? Proper Syntax when using Dimension Expression Builder

I would guide you to Qlik Sense help where they have provided syntax will all examples:

Home ‒ Qlik Sense

Community Browser