topic Re: Linking Listbox with charts in QlikView

Linking Listbox with charts

Mon, 09 Feb 2015 13:17:37 GMT

Hello,

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!

AbhijitBansode — Mon, 09 Feb 2015 13:20:46 GMT

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)

Mon, 09 Feb 2015 14:00:24 GMT

You're the God! Thanks man!!! Shall keep you posted if I bump into more roadblocks.

Mon, 09 Feb 2015 20:39:55 GMT

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!

Regards