Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm new to Qlik Sense, I normaly use POWER BI but our company is implementing Qlik Sense as the new standard.
I'm trying the following, have a colomn with a date in it.
I want a new colomn with 3 values based on this date field.
If the date field is empty it should give a "-"
If the date field is today or before it should say "over due"
If the date field is after today it should say "OK"
how do I do this is Qlik Sense?
the power BI command for it is this :
Follow up - Status = IF('Topdesk Data'[Date (Follow up)] = BLANK(); "-";IF('Topdesk Data'[Date (Follow up)] <= (NOW());"Over Due";"OK"))
THX for you help.
Show be something like this as your calculated dimension.
IF([Date (Follow up)]<=Today(),'over due',IF([Date (Follow up)]>Today(),'OK','-'))
Regards
Andy
Show be something like this as your calculated dimension.
IF([Date (Follow up)]<=Today(),'over due',IF([Date (Follow up)]>Today(),'OK','-'))
Regards
Andy
Thanks, that it! thx!
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post). To see the button, you will have to visit the topic (as it will not show in topic preview).
If not, please make clear what part of this topic you still need help with .
Your welcome.