topic Re: If Condition ? in QlikView

If Condition ?

Tue, 25 Mar 2014 17:49:36 GMT

Any Body can post applications related to

1. If condition

2. If Else condition

3. Nested If condition

Thanks,

Helen

Re: If Condition ?

Tue, 25 Mar 2014 18:32:31 GMT

Attached is a basic example.

Hope it helps.

Thanks

AJ

Re: If Condition ?

Wed, 26 Mar 2014 06:39:10 GMT

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

Re: If Condition ?

mangalsk — Wed, 26 Mar 2014 07:55:52 GMT

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