topic Re: Simplify Expression in QlikView

Simplify Expression

rajeshvaswani77 — Mon, 08 Sep 2014 08:20:17 GMT

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

Re: Simplify Expression

sushil353 — Mon, 08 Sep 2014 08:22:06 GMT

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

create a variable say fx = sum(value)

HTH

Sushil

Re: Simplify Expression

vijay_iitkgp — Mon, 08 Sep 2014 08:23:23 GMT

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.

Re: Simplify Expression

tresB — Mon, 08 Sep 2014 08:36:42 GMT

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