multiple dimension combine front end

[sanjujeeboy]

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 ?

[bhavyagrb]

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