Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

count amount of different values of combined dimension

Hi com,

sorry for this Header! my english is by far not the best and i don't know how to keep this short.

I have a Dimension that combines two table coloumns. And i want to know how many different value versions there are for this combined dimension.

so for example we have:

typ     name

1          a

2          e

3          c

4          b

4          b

so in a combined dimension we would have 4 bar's. In my case there are so many that i cant count them hand by hand.

Can someone help me or has advices.

Thanks in advance

-Eric

Tags (2)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: count amount of different values of combined dimension

You want to count distinct combination of typ and name?

May be this:

Count(DISTINCT typ&name)

2 Replies
sunny_talwar
Not applicable

Re: count amount of different values of combined dimension

You want to count distinct combination of typ and name?

May be this:

Count(DISTINCT typ&name)

Not applicable

Re: count amount of different values of combined dimension

great and fast solution!! thanks once again!

great see u hitting 100.000!!