topic Re: Hide list box based on chart selection in container in QlikView

Hide list box based on chart selection in container

agni_gold — Tue, 03 May 2016 12:43:51 GMT

Hi I have a situation , i want to show hide a list box based on chart selection in container ,

Is this possible ?

Please suggest.

Re: Hide list box based on chart selection in container

Gysbert_Wassenaar — Tue, 03 May 2016 13:11:07 GMT

What you cannot do is check which chart in a container is active. Activating a chart in a container does not fire an event that can be used to do something.

It is possible to use field selections to show/hide a listbox. If you select a value in a chart dimension you can check the possible values of that field and show/hide a listbox. You can enable the Conditional option of the listbox on the layout tab of the properties window of the listbox. Then you can enter an expression that returns true or false to show or hide the listbox. Something like =max(match([My Field], 'My Value')) to check if My Value is a possible value in field My Field.

Re: Hide list box based on chart selection in container

agni_gold — Tue, 03 May 2016 13:46:09 GMT

Thanks ,

But requirement is like ,

i have 5 charts in container , but when first chart selected from container a list box should appear , which has some value and that chart will change based on values in list box.

Re: Hide list box based on chart selection in container

Gysbert_Wassenaar — Tue, 03 May 2016 15:07:21 GMT

As I said above: not possible.

As an alternative create a small inline table in the script with a record for each chart with a field containing a descriptive name for the chart. Add a listbox to your document for that new field and let the user select a chart from that listbox. That is a selection in a field and as I described above that selection can be used to show both the chart and that other listbox you want to show.

Re: Hide list box based on chart selection in container

Anonymous — Tue, 17 Oct 2017 10:04:01 GMT

Hi..i have a similar requirement.. did you find an answer to it..I am using QV11