Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

akashpatel
New Contributor

Show/Hide column based on Listbox value selection

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.

3 Replies
laddu_927
Valued Contributor

Re: Show/Hide column based on Listbox value selection

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

Not applicable

Re: Show/Hide column based on Listbox value selection

Hi Akash,

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

list.JPG

Attached the qvw for your reference.

Regards,

Vivek

sasikanth
Valued Contributor III

Re: Show/Hide column based on Listbox value selection

Hi,

Try this exp in Dimenion-> calculation condition

GetselectedCount(FilterYearMonth)=0