topic Re: comparison operator in if statement in QlikView

comparison operator in if statement

Fri, 14 Mar 2014 11:30:57 GMT

In the expression or script, I want to add logic, volumn ("greater" or "less" depends on the vSet boolean value) than 10.

if(volumn"????"10, dosth, dosthelse)

My question is how to write the "????" part.

It should be something like. if(greater=1,>,<).

I have tried:

if(volumn&if(greater=1,'>','<')&10, dosth, dosthelse), but it is not working.

jvitantonio — Fri, 14 Mar 2014 11:40:01 GMT

Hi, not sure what you ar trying to achieve, but you can use if like this:

If(Volume > 1 OR Volume < -1, Expression, ElseExpression)

If(Volume >1 AND Volume <10, Expression, ElseExpression)

If(Volume = 1, Expression, ElseExpression).

I Hope this helps.

whiteline — Fri, 14 Mar 2014 11:48:16 GMT

Hi.

LET vSet = '>';

if(volumn$(vSet)10, dosth, dosthelse)

cgdonders — Fri, 14 Mar 2014 11:48:43 GMT

Like this:

If (vSet = 0, if (volumn <10, dosth, dosthelse), if (vSet =1, if (volumn> 10, dosth, dosthelse))

Fri, 14 Mar 2014 11:53:22 GMT

This is the logic I want, but would be much better if I can change comparison operator within a if statement.

I got the correct answer.

if(volumn$(=if(greater=1,'>','<'))10, dosth, dosthelse)

Fri, 14 Mar 2014 11:57:18 GMT

This syntax does not work.

cgdonders — Fri, 14 Mar 2014 12:04:45 GMT

then the answer of whiteline must do the trick, I think.

In my reply I forgot a ')'. it must be like:

If ($(vSet) = 0, if (volumn <10, dosth, dosthelse), if ($(vSet) =1, if (volumn> 10, dosth, dosthelse)))