Discussion Board for collaboration related to QlikView App Development.
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 ?
You can try Calculated dimension in Table or using Filter Pane :
Or In Qlikview use ListBox>Properties>Fields>Expression: =if([Target.Traffic]='LP','PP', if([Target.Traffic]='Retailer','EP',[Target.Traffic]))
Hope this helps you!!