topic Mistake in If statement in QlikView

Mistake in If statement

Tue, 03 Nov 2015 10:01:33 GMT

Hi All,

Below is the if query used in the expression

if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',Enq_ContactName,

if(Off_Status='Auto Approved',Enq_ContactName,

if(Off_Status='Pending Approval',Enq_ContactName,

))))

Above expression gives 9 records. But when i select individual Off_Status it shows more.

Please help me with this.

Attached the Qvw.

Regards,

Keerthi KS

Re: Mistake in If statement

tamilarasu — Tue, 03 Nov 2015 10:04:26 GMT

Attachment missing..!!!!

Re: Mistake in If statement

andrespa — Tue, 03 Nov 2015 10:04:33 GMT

Don't see thw qvw...

Re: Mistake in If statement

jagan — Tue, 03 Nov 2015 10:05:08 GMT

May be because of this conditions data is filtering

Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

did you applied in your selections?

There is no attachment in your post.

Regards,

Jagan.

Re: Mistake in If statement

Anonymous — Tue, 03 Nov 2015 10:07:01 GMT

TRY BRACKETS AROUND FIRST EXPRESSION

if((Off_Start_Date<>Null())

and (len(trim(TermSheetSignedDateTime))=0),

Re: Mistake in If statement

Anonymous — Tue, 03 Nov 2015 10:08:09 GMT

Try this one:

if(Off_Start_Date<>Null() and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft' or Off_Status='Auto Approved' or Off_Status='Pending Approval',Enq_ContactName

))

Re: Mistake in If statement

Tue, 03 Nov 2015 10:10:56 GMT

Yes i have applied. Attached the Qvw

Re: Mistake in If statement

Tue, 03 Nov 2015 10:11:44 GMT

Still its the same

Re: Mistake in If statement

Tue, 03 Nov 2015 10:13:18 GMT

tried but not working

Re: Mistake in If statement

Anonymous — Tue, 03 Nov 2015 10:21:39 GMT

if you define an else you get more data

if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',Enq_ContactName,

if(Off_Status='Auto Approved',Enq_ContactName,

if(Off_Status='Pending Approval',Enq_ContactName, 'else'

))))

so obviously there are more datasets wgich doesnot meet any of the above conditions

Re: Mistake in If statement

sasiparupudi1 — Tue, 03 Nov 2015 10:33:42 GMT

Try the following to see why your if condition is having a problem

if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',Enq_ContactName,

if(Off_Status='Auto Approved',Enq_ContactName,

if(Off_Status='Pending Approval',Enq_ContactName,Off_Status

))))

hth

Sasi

Re: Mistake in If statement

Tue, 03 Nov 2015 10:35:59 GMT

when i select the Off_Status it shows the data. But in the expression its faining