topic Hide/Unhide Charts based on selections in a List box ? in QlikView

Hide/Unhide Charts based on selections in a List box ?

onetwothree123 — Thu, 16 Feb 2012 20:31:12 GMT

How to Hide/Unhide Charts based on selections in a List box ?

I have a requirement where chart A should be displayed if I have A as a selection in List box. or

chart B should be displayed if I have B as a selection in List box.

What would be the best way to do it.

Thu, 16 Feb 2012 20:42:36 GMT

Set the list box to always 1 value selected.

Then in each chart use the expression on Show Conditional under the layout tab:

GetFieldSelections(Selection)='A'

//This displays the chart if A is selected.

GetFieldSelections(Selection)='B'

//This displays the chart if B is selected.

Thu, 16 Feb 2012 20:46:20 GMT

AJ, I believe this should work.

In chart A, properties, layout, show, conditional, type in yourfieldname='A'

In Chart B, properties, layout, show, conditional, type in yourfieldname='B'

The when you select either A or B the appropriate Chart will display.

Scott

onetwothree123 — Thu, 16 Feb 2012 21:05:16 GMT

Thank you Marc and Scott.

It worked

Fri, 17 Feb 2012 02:53:17 GMT

You are welcome. Please remember to mark your post with "Correct Answer"