Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shahfaisalq
Contributor III
Contributor III

how to Change specific date and leave that field empty.

Hi Every one,

I am at the beginner stage and still learning the Qlik Sense.

Right now i don't have any idea how to do the following.

our requirement is to change the date 9001-12-31 in the Start_Date and End_Date column in a specific table and leave the field empty for that specific date. what will be the query in data load editor. how i have to use it.

Please help me with that.

Thank you,

Regards,

ShahFaisal Qayyum

1 Reply
sunny_talwar

May be try this

If(Start_Date = '9001-12-31', Null(), Start_Date) as Start_Date,

If(End_Date = '9001-12-31', Null(), End_Date) as End_Date,