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: 
erwinvullers
Contributor
Contributor

IF Statement to give Output

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.

1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

Show be something like this as your calculated dimension.

IF([Date (Follow up)]<=Today(),'over due',IF([Date (Follow up)]>Today(),'OK','-'))

Regards

Andy

View solution in original post

4 Replies
ogster1974
Partner - Master II
Partner - Master II

Show be something like this as your calculated dimension.

IF([Date (Follow up)]<=Today(),'over due',IF([Date (Follow up)]>Today(),'OK','-'))

Regards

Andy

erwinvullers
Contributor
Contributor
Author

Thanks, that it! thx!

oknotsen
Master III
Master III

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 .

May you live in interesting times!
ogster1974
Partner - Master II
Partner - Master II

Your welcome.