Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Linking Listbox with charts

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!

1 Solution

Accepted Solutions
cabhijit
Valued Contributor

Re: Linking Listbox with charts

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)

3 Replies
cabhijit
Valued Contributor

Re: Linking Listbox with charts

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)

Not applicable

Re: Linking Listbox with charts

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

Not applicable

Re: Linking Listbox with charts

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

Community Browser