Variabilize Expression - switch fields within expression

Tue, 19 Jan 2016 11:27:00 GMT

Hello the community,

Is there any way to modify/switch the content of an expression by simply turning off/on one button ?

I have Budget/FCT1/FCT2 data, that I compare with actuals.

Instead of having one table showing all the columns, I want to switch my field within my expression.

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly FCT1 (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat )

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly FCT2 (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat ) \

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly Budget (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat )

I did use the "group" button for the table, it works fine, but I also have many text objects on my application, that's why I thought that switching the field of my expression using a button/switch would be better.

Any idea ?

Thank you

Re: Variabilize Expression - switch fields within expression

maxgro — Tue, 19 Jan 2016 19:01:52 GMT

try

Dynamic Tables and Graphs

Re: Variabilize Expression - switch fields within expression

Tue, 01 Mar 2016 21:20:56 GMT

Thank you Max

Sorry for the late answer

topic Re: Variabilize Expression - switch fields within expression in QlikView

Variabilize Expression - switch fields within expression

Re: Variabilize Expression - switch fields within expression

Re: Variabilize Expression - switch fields within expression