Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,