topic Re: Show/Hide Columns in a straight Table using a variable in QlikView

Show/Hide Columns in a straight Table using a variable

Thu, 15 Sep 2016 11:37:22 GMT

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

Re: Show/Hide Columns in a straight Table using a variable

Thu, 15 Sep 2016 16:20:44 GMT

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

Re: Show/Hide Columns in a straight Table using a variable

krishnacbe — Thu, 15 Sep 2016 16:27:19 GMT

Hi,

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

example if(vEurShow=0,1,0)

Re: Show/Hide Columns in a straight Table using a variable

Thu, 15 Sep 2016 17:26:26 GMT

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

Re: Show/Hide Columns in a straight Table using a variable

avinashelite — Thu, 15 Sep 2016 17:31:42 GMT

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

vEurShow

if(vEurShow =1,1,0)

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

Re: Show/Hide Columns in a straight Table using a variable

Fri, 16 Sep 2016 08:30:25 GMT

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