Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try to create calculated dimension in your chart object (listbox/pivot table)
=pick(Match(Company,'WH'),Product)
Hi,
another solution might be:
hope this helps
regards
Marco