Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If Condition ?

Any Body can post applications related to

1. If condition

2. If Else condition

3. Nested If condition

Thanks,

Helen

3 Replies
Not applicable
Author

Attached is a basic example.

Hope it helps.

Thanks

AJ

Not applicable
Author

HI Ajay, help me to write in QV Scripting at Back End....

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

mangalsk
Creator III
Creator III

Hello,

Try this:

=if(service_type='CPE','st1',if(Value>0,'st2',if(isnull(Value),'st3',if(isnull(service_type),'st5','st4'))))

and provide sample data if it doesn't work.

Regards