topic Re: Dynamic Grouping in straight table depending upon selection in QlikView

Dynamic Grouping in straight table depending upon selection

Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have 3 dimensions - A,B,C and based on selection of dimension through dropdown. I want to group data according to that dimension .

I can do this using if else but want to keep it more dynamic as dimensions cab be increased later.

suppose data is like this

A value B C

a1 10 b1 c1

a2 20 b2 c2

a3 30 b3 c3

on selection of A

A Sum(<A> value)

on selection of B

B Sum(<B> value)

on selection of C

C Sum(<C> value)

regards

Anubhav

Thu, 04 Aug 2016 19:18:03 GMT

you can resolve this on script, i think you perfomnace will be better this

Table:

load A as info,

'A' as Type,

value

from ...;

concatenate(Table)

load B as info,

'B' as Type,

value

from ...;

concatenate(Table)

load C as info,

'C' as Type,

value

from ...;

Thu, 04 Aug 2016 19:23:16 GMT

you can use ciclic group

setings->document propetis->group->ciclec group->new

and use the group =SUM("name_of_your_group")