Count different values over dimensions

josemaria_cabre — Sat, 16 Nov 2024 05:50:43 GMT

Hi Everyone,

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

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

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.

Re: Count different values over dimensions

sonusagar — Tue, 14 May 2019 13:03:59 GMT

Hello,

Using Crosstable in scripting, you will get the output.

Attaching the qvf and output.

Thanks,

Sonu Sagar

Re: Count different values over dimensions

josemaria_cabre — Wed, 15 May 2019 07:10:25 GMT

Works perfect,

Thanks a lot for your help!.

Regards,

Jose.

topic Re: Count different values over dimensions in App Development

Count different values over dimensions

Re: Count different values over dimensions

Re: Count different values over dimensions