Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
josemaria_cabre
Contributor III
Contributor III

Count different values over dimensions

Hi Everyone,

Let's imagine we have this table, where every dimension can contain different values from 0 to 5:

tbl1.png

And we want to get another table, that counts how many times each value appears on corresponding dimension:

tbl2.png

How can I get the dimension 'Value'?, and how do I count appereances of each value on this new dimension?

How can I add totals to this table as well?

I tried to do something like 

Count({<Dim1 = {'0'}>} DISTINCT ID)

but this involves creating a different expression for each value and for each dimension.  I'm sure there must be an easier way to achieve my pretending table.

Can anyone help with this? I'm attaching a .qvf file with this example dimensions and values.

Thanks in advance,

Jose.

 

 

Labels (2)
1 Solution

Accepted Solutions
sonusagar
Partner - Contributor II
Partner - Contributor II

Hello,

Using Crosstable in scripting, you will get the output.

Attaching the qvf and output.

 

Thanks,

Sonu Sagar

View solution in original post

2 Replies
sonusagar
Partner - Contributor II
Partner - Contributor II

Hello,

Using Crosstable in scripting, you will get the output.

Attaching the qvf and output.

 

Thanks,

Sonu Sagar

josemaria_cabre
Contributor III
Contributor III
Author

Works perfect,

Thanks a lot for your help!.

 

Regards,

Jose.