Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shahfaisalq
New Contributor

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
MVP
MVP

Re: how to Change specific date and leave that field empty.

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,

Community Browser