Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a list box with multiple items in it for e.g.
- Percent of xyz
- Percent of abc
And I have a chart for each of these percents depicting Current Year vs. Prior Year.
So when I select "Percent of xyz" I would like to only see the chart for it and the other chart should say "No data to display"
Please advise. Thanks!
Go to Solution.
For both the charts, Set the calculation condition from the General tab:
for first chart :
if(GetFieldSelections(ListBoxFieldName)='Percent of xyz',1,0)
for second chart
if(GetFieldSelections(ListBoxFieldName)='Percent of abc',1,0)
You're the God! Thanks man!!! Shall keep you posted if I bump into more roadblocks.
So far the following has been achieved:
When I select "Percent of xyz" from the list box I would see it's chart
When I select "Percent of abc" I would see it's chart
However, what I want is that the chart for xyz minimizes. How to do so? Thanks!