topic How to use variable in IF statement in QlikView

How to use variable in IF statement

Fri, 21 Aug 2015 11:34:39 GMT

Hi,

I'm bothering myself with one problem.

I would like to compare a value that I calculate and it is stored in variable with the Value from Field and then to color Background.

When I change the variable with inputed value it works fine, but with variable not.

What I am doing wrong?

This the End result.

variable value in text box

Is it problem with compare string and number? Or?

Please advice.

Thx

Tom

Re: How to use variable in IF statement

Kushal_Chawda — Fri, 21 Aug 2015 11:37:33 GMT

what is the expression for that variable?

Try to apply num function over expression like num(expression)

Re: How to use variable in IF statement

Fri, 21 Aug 2015 11:40:29 GMT

Have already tried this and many other ideas.

Will try again.

Thx

Re: How to use variable in IF statement

sasiparupudi1 — Fri, 21 Aug 2015 11:45:33 GMT

your formatting of the number is different to the value that is being compared..

one is having . and another is having a comma..

you can not compare number with a string

fix it and it should work

hth

Sasi

Re: How to use variable in IF statement

Fri, 21 Aug 2015 11:49:27 GMT

just a minute ago I've changed the Number format in properties.

Still no success.

I 'm aware the problem lies comeprrison.

How can I define that these two values are string?

thx

Tom

Re: How to use variable in IF statement

sasiparupudi1 — Fri, 21 Aug 2015 11:54:43 GMT

you could may be try

num(replace('$(vX)',',','.'),'0.00')

where vX is your variable

Re: How to use variable in IF statement

Fri, 21 Aug 2015 11:57:49 GMT

Just did it in Load statement.

I was loading dataset with comma, instead .

Will see result.

thx