Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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