topic Re: IF Else Condition? in QlikView

IF Else Condition?

Mon, 24 Mar 2014 06:15:33 GMT

HI, help me to write in QV Scripting....

if(service_type==CPE)

{

SQL Select Stmt...

if(Value>0)

{

SQL select Stmt...

If (No data)

{

SQL select Stmt..

}

else

{

SQL select Stmt..

If (No data)

{

SQL select Stmt..

}

Thanks,

Helen

Re: IF Else Condition?

Anonymous — Mon, 24 Mar 2014 06:19:31 GMT

if(service_type='CPE') then

SQL Select Stmt...

elseif(Value>0) then

SQL select Stmt...

else If (No data) then

SQL select Stmt..

else

SQL select Stmt..

elseifIf (No data) then

SQL select Stmt..

Re: IF Else Condition?

Mon, 24 Mar 2014 06:39:22 GMT

IF service_type='CPE'

THEN

SQL Select Stmt...

IF Value>0

THEN

SQL select Stmt...

IF (No data)

THEN

SQL select Stmt..

ELSE

SQL select Stmt..

IF (No data)

THEN

SQL select Stmt..

ENDIF

Re: IF Else Condition?

sushil353 — Mon, 24 Mar 2014 06:54:31 GMT

Hi Helen,

Try this:

IF service_type='CPE' THEN

SQL Select Stmt...

IF Value>0 THEN

SQL select Stmt...

IF isnull(field name) THEN

SQL select Stmt.

ELSE

SQL select Stmt..

IF isnull(field name) THEN

SQL select Stmt..

ENDIF

ENDIF;

HTH

Sushil