topic Show/Hide column based on Listbox value selection in QlikView

Show/Hide column based on Listbox value selection

Anonymous — Wed, 22 Feb 2017 09:30:42 GMT

I have a column monthyear(201601).

I create straight table in which I put Monthyear column.

How to hide the value of column if I select any value from the filter monthyear.

Suppose if I select 201601 then column monthyear must be hide from straight table and if I clear all selection then monthyear column should not be hide.

Please provide me solution ASAP.

Re: Show/Hide column based on Listbox value selection

Anonymous — Wed, 22 Feb 2017 10:21:15 GMT

Use conditional in straight table expressions.

Object properties- > Dimensions - > Click on the column - > check conditional and Write below expression.

If the column should be hidden only when the value selected is "201601 " then something like

getfieldselections( filtername )<>'201601'.

Or if you want the column to be hidden if any value in the filter is selected then something like

GetSelectedCount( filtername ) = 0.

Hope it helps

Re: Show/Hide column based on Listbox value selection

Wed, 22 Feb 2017 10:28:42 GMT

Hi Akash,

You can use getselectedcount(monthyear) option in enable conditional a shown below.

Attached the qvw for your reference.

Regards,

Vivek

Re: Show/Hide column based on Listbox value selection

sasikanth — Wed, 22 Feb 2017 11:38:57 GMT

Hi,

Try this exp in Dimenion-> calculation condition

GetselectedCount(FilterYearMonth)=0