topic Group dimension by selection in QlikView

Group dimension by selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello there!

I was wondering if there is a way to group dimensions in a chart by the selection of the user. I will put an example to make it easier:

Imagine that i have dimensions A,B,C. Imagine now the following table:

expressions

A values

B values

C values

Can i do something so when the user selects (for example) A and B the table appers like this:

expressions

AB avg(values)

C values

If the user selects A-C, C-B or whichever possible combination expect the respective results.

Thanks fot the help!

Lluís

its_anandrjs — Mon, 13 Nov 2017 16:21:08 GMT

What is expected O/P.

its_anandrjs — Mon, 13 Nov 2017 16:22:30 GMT

Or you can use the Pick() , ValueList() function combination for this.

jpenuliar — Mon, 13 Nov 2017 16:23:52 GMT

you probably could use GetfieldSelections() to achieve this