Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjujeeboy
Creator
Creator

multiple dimension combine front end

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 ?

1 Reply
bhavyagrb
Partner
Partner

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