Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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