topic Show/Hide Columns in a Straight Table Based on List Box Selection in QlikView

Show/Hide Columns in a Straight Table Based on List Box Selection

Anonymous — Sun, 21 Sep 2014 21:09:38 GMT

Is it possible to show/hide a column in a straight table based on a list box selection?

I have a column listed as Destination (Example: CLE, DFW, ATL etc.). I have other columns listed as A xxx, A yyy, B xxx, B yyy, and so on.

I am needing to hide or show the various A and B columns based on the destination that is selected in the list box. So for example if CLE is selected, only columns A xxx and B yyy show. Or if ATL is selected columns A xxx and B xxx show.

Thanks,

Chris

Re: Show/Hide Columns in a Straight Table Based on List Box Selection

Anonymous — Sun, 21 Sep 2014 21:22:28 GMT

Use "Enable Conditional" for the dimension:

GetFieldSelections(Destination) = 'CLE'

Re: Re: Show/Hide Columns in a Straight Table Based on List Box Selection

Anonymous — Sun, 21 Sep 2014 21:52:20 GMT

I think I was able to figure this out. Thanks konstantins for the quick reply!

Chris

Re: Show/Hide Columns in a Straight Table Based on List Box Selection

MarcoWedel — Sun, 21 Sep 2014 22:22:51 GMT

Hi,

one possible solution:

hope this helps

regards

Marco

Re: Show/Hide Columns in a Straight Table Based on List Box Selection

jagan — Mon, 22 Sep 2014 02:19:27 GMT

Hi,

Check this link

Adhoc reporting in Qlikview

Hope it helps you.

Regards,

Jagan.