topic Re: If statement with 2 conditions . in QlikView

If statement with 2 conditions .

Mon, 05 May 2014 17:30:24 GMT

Hello everybody , I need to write an if statement with multiple conditions for example :

if(enter_time+exit_time) >= 2, count(vhcls) .

is there an if formula to do this or should I use another function?

many thanx.

Re: If statement with 2 conditions .

Anonymous — Mon, 05 May 2014 17:53:03 GMT

You can use as many condition as you want, but typically the if statement is inside aggregation:

count(if((condition1 or condition2) and (condition3 or condition4) and condition5, vhcls))

Re: If statement with 2 conditions .

Clever_Anjos — Mon, 05 May 2014 17:55:21 GMT

the syntax is

IF(Cond,TrueExpression,FalseExpression)

where Cond can be

ExpressionA AND|OR ExpressionB AND|OR ExpressionC and so on

Re: If statement with 2 conditions .

Mon, 05 May 2014 18:47:16 GMT

Thank you. I mean could I use variables inside an if statement ? If so what's the syntax ?

Many thanx.

Re: If statement with 2 conditions .

Anonymous — Mon, 05 May 2014 19:23:22 GMT

You can use variables.
Syntax - it depends what's the content of the variables, and how you're going to use them. It could be a value, for example your '2' in the opening post can be replaced with a variable. Or it could be the whole condition, or its part. If you want a more specific answer, upload your application.

Re: If statement with 2 conditions .

MarcoWedel — Mon, 05 May 2014 22:11:22 GMT

maybe you meant

if(enter_time>= 2 AND exit_time >= 2, count(vhcls))

regards

Marco

Re: If statement with 2 conditions .

anushahegde — Thu, 26 Apr 2018 09:06:45 GMT

If there are 2 expressions in the fasle expression how to write it?

Re: If statement with 2 conditions .

puneetagarwal — Thu, 26 Apr 2018 10:03:02 GMT

Can you tel some example?

Re: If statement with 2 conditions .

sasiparupudi1 — Thu, 26 Apr 2018 13:41:34 GMT

Count(if((enter_time+exit_time) >= 2,vhcls)

vMyVariable=(enter_time+exit_time)

Count(if($(vMyVariable)>2,vhcls)

Re: If statement with 2 conditions .

MarcoWedel — Thu, 26 Apr 2018 18:53:56 GMT

Please open a thread for your questions instead of adding them to existing ones.

thanks

regards

Marco

Re: If statement with 2 conditions .

cmorri1988 — Fri, 27 Apr 2018 15:13:46 GMT

Hi there,

I would create field in the script for this:

New_field:

LOAD

enter_time+exit_time as duration

FROM...

and use this measure:

Count(if((duration) >= 2,vhcls)

Hope this helps