Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
linlookzdj
Contributor
Contributor

Show field content if match another field's content

Dear Qlikview Experts,

I have 2 fields, product( A / B / C ) and Company( WH / TH / BC ). May I know is there a way for a list box/pivot table to show the possible values under product field if company is WH? I want it to filter automatically without user clicking on 'WH' under company field. Any ideas would be greatly appreciated.

Best Regards

2 Replies
devarasu07
Master II
Master II

Hi,

Try to create calculated dimension in your chart object (listbox/pivot table)

=pick(Match(Company,'WH'),Product)

Capture.JPG

MarcoWedel

Hi,

another solution might be:

QlikCommunity_Thread_285298_Pic2.JPG

QlikCommunity_Thread_285298_Pic3.JPG

QlikCommunity_Thread_285298_Pic1.JPG

hope this helps

regards

Marco