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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in If statement

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

Labels (1)
2 Replies
MK_QSL
MVP
MVP

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
Master III
Master III

It will show the null values as expression output.