Show/Hide column based on Listbox value selection

[Anonymous]

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.

[Anonymous]

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

[#3]

Hi Akash,

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

Attached the qvw for your reference.

Regards,

Vivek

[sasikanth]

Hi,

Try this exp in Dimenion-> calculation condition

GetselectedCount(FilterYearMonth)=0