Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

IF Else Condition?

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
gupta_n8
Valued Contributor II

Re: IF Else Condition?

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

Not applicable

Re: IF Else Condition?

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

sushil353
Honored Contributor II

Re: IF Else Condition?

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

Community Browser