Show/Hide Columns in a straight Table using a variable

[#1]

Dear Community,

I am sure you know this but this is driving me crazy!

I want to create a table that shows sales in EUR as functional currency and the local currencies of the Group companies e.g. USD. I created a variable vEurShow and set the value to 0 ( to display EUR) or 1 (to display local currency)using two buttons named EUR and LC.

I did the following: Chart Properties -> Expressions . For the column in question I choose 'Enable' and 'Conditional' but I did not find out the correct expression to enter as condition.

Any ideas?

Thanks in advance

Stephan

[#2]

Hi Stephan,

Are you looking to switch a currency column from Euro to USD on the click of a button?

If so, the conditional option will not work, as conditional will either hide or show the column.

If you can post some example screenshots or even the qvw that would be very helpful.

Thanks,

- Stan

[krishnacbe · Accepted solution]

Hi,

Did you set the Action for the Button to set the variable value to 1.

example if(vEurShow=0,1,0)

[#4]

I have two buttons: one set the variable to 0 the other to 1.

I tried your proposal if(vEurShow=0,1,0). But it did not work. I leave office now and retry tomorrow. (7:25 pm)

Thanks

Stephan

[avinashelite]

Your on track just add the expression in the conditional > chart properties >expression

vEurShow

OR

if(vEurShow =1,1,0)

don't forget to add the action in the button/text box to set the values

[#6]

I thank you all.

if(vEurShow=0,1,0) is correct.

Maybe it was a simple typing error that I did not realize.

Have a nice day

Stephan