IF Else Condition? - Qlik Community - 612073

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!

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

3 Replies

Author

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..

Author

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

ENDIF

ENDIF

ENDIF

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

ENDIF

ENDIF;

HTH

Sushil