Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can save your f(x) in a variable and use that anywhere..
create a variable say fx = sum(value)
HTH
Sushil
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.
Put f(x) in a variable and use that variable in your expression. QlikView would calculate it once and use the value twice.