topic How to return original value in "if" function in QlikView

How to return original value in "if" function

gzboy008 — Mon, 03 Jun 2013 09:53:04 GMT

Hello everyone,

May I know is there any functions can instead of "if" function? What I need to do is similar to "if" function, but "if" function can't return original value.

Please have a look my example:

My formula is:

if(epx>500,500,epx)

but exp here is a complicated formula, so copy epx will cause a large amount of repeated coding.

Is there any functions can retrieve the original value and acting similar as "if" function?

Thanks~

Re: How to return original value in "if" function

alexandros17 — Mon, 03 Jun 2013 09:56:22 GMT

If epx is a formula computed in another column (for example Col1) you can hide Col1 and use it as an expression, in this way your if will be:

if([Col1]>500, 500, [Col1])

(Hideing a column doesn't work with pivot graph.

Only an idea but hope it helps

Re: How to return original value in "if" function

gzboy008 — Mon, 03 Jun 2013 10:16:49 GMT

It's a great solution. Thanks so much~