topic Re: multiple dimension combine front end in QlikView

multiple dimension combine front end

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

HI all,

i have a dimension "Traffic" in table 1 which has values 'EP', 'PP'

another dimension "Target.Traffic in table 2 which has values 'LP' , 'Retailer'

in front end i want to create a filter "Traffic" which should have only 2 values EP and PP from both tables. (from table 2 wherever its LP it should be 'PP' and wherever Reatailer it should be EP)

how to acheieve this in front end ?

Re: multiple dimension combine front end

bhavyagrb — Wed, 02 Sep 2020 13:02:54 GMT

Hi,

You can try Calculated dimension in Table or using Filter Pane :

=if([Target.Traffic]='LP','PP', if([Target.Traffic]='Retailer','EP',[Target.Traffic]))

Or In Qlikview use ListBox>Properties>Fields>Expression: =if([Target.Traffic]='LP','PP', if([Target.Traffic]='Retailer','EP',[Target.Traffic]))

Hope this helps you!!

Regards,

Bhavya