Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.