how to Change specific date and leave that field empty.

[shahfaisalq]

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

[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,