Simplify Expression

[rajeshvaswani77]

Hi All,

We have a complex expression, I am calling this f(x)

the condition

if(f(x) =0, 0, f(x) -1)

Note that f(x) can also return negative values, if so these are required.

We do not want to do the complex calculation twice, is there a QlikView function that can help me achieve this?

Something like QlikViewfunction(f(x))...

thanks,

Rajesh Vaswani

[sushil353]

you can save your f(x) in a variable and use that anywhere..

create a variable say fx = sum(value)

HTH

Sushil

[vijay_iitkgp]

Hi , If you are using Straight table then you can create Expression F(x) and make it hidden in presentation tab. And use your conditional expression If(F(x)=0,-----) in another expression. Hope this helps.

[tresB]

Put f(x) in a variable and use that variable in your expression. QlikView would calculate it once and use the value twice.