Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erwinvullers
New 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
Honored Contributor II

Re: IF Statement to give Output

Show be something like this as your calculated dimension.

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

Regards

Andy

4 Replies
ogster1974
Honored Contributor II

Re: IF Statement to give Output

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
New Contributor

Re: IF Statement to give Output

Thanks, that it! thx!

oknotsen
Honored Contributor III

Re: IF Statement to give Output

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
Honored Contributor II

Re: IF Statement to give Output

Your welcome.

Community Browser