topic Issue in If statement in QlikView

Issue in If statement

Wed, 28 Oct 2015 07:02:27 GMT

Hi All,

Below is the if statement

If((CurrentStatus<>'Expired' or CurrentStatus<>'Dropped'),

if(Enq_Followup_Date<>Null() and len(trim(SitevisitDate))=0 and len(trim(Off_Start_Date))=0

and len(trim(TermSheetSignedDateTime))=0

,Enq_ContactName)

)

But when Currentstatus is selected its showing data for Expired and Dropped also.

Please help me with this. is there any mistake in if statement.

Regards,

Keerthi KS

MK_QSL — Wed, 28 Oct 2015 07:04:23 GMT

If(CurrentStatus<>'Expired' or CurrentStatus<>'Dropped') and

Enq_Followup_Date<>Null() and len(trim(SitevisitDate))=0 and len(trim(Off_Start_Date))=0

and len(trim(TermSheetSignedDateTime))=0

,Enq_ContactName)

Check number of closing brackets..

sujeetsingh — Wed, 28 Oct 2015 07:05:09 GMT

It will show the null values as expression output.