topic Re: Select jerarquic dimenssion with field? in QlikView

Select jerarquic dimenssion with field?

Tue, 03 Feb 2015 13:43:30 GMT

I have this inline table

NAME

DOWN

i wanna have ONE object and if i select in a list table "up" or "up" and "down" i use JERARQUIC DIMMENSION 1

but if i select "down" i use JERAQUIC DIMENSION 2

all of this in one object

thank you

Greetings

Peter_Cammaert — Tue, 03 Feb 2015 14:01:13 GMT

Add a calculated dimension that says:

=if(match(getfieldselections(NAME, ';'), 'UP'), [JERARQUIC DIMMENSION 1], [JERARQUIC DIMMENSION 2])

Tue, 03 Feb 2015 14:12:33 GMT

thank you,

what is the reason of the ; ?

thank you

Peter_Cammaert — Tue, 03 Feb 2015 15:11:03 GMT

Separates multiple values. If you have UP & DOWN selected in field NAME, the function will return 'DOWN;UP'.