Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

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)

View solution in original post

2 Replies

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)

View solution in original post

Not applicable

Re: count amount of different values of combined dimension

great and fast solution!! thanks once again!

great see u hitting 100.000!!