Show field content if match another field's content

[Anonymous]

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

[devarasu07]

Hi,

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

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

[MarcoWedel]

Hi,

another solution might be:

hope this helps

regards

Marco