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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

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.