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: 
AH
Creator III
Creator III

If statement problem

Hi,

I have a expression like this:

if

(Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! ')

I want to make the expression like:

If  (Today()-[DAX Service Order Created Date] =3 then 'Showw Warning'

If its >3 then show 'Trouble'

And If its ❤️ then show 'All is Good'.

Can i have all these three logic in one if statement?

Thanks,

Ahmed

6 Replies
Colin-Albert

Try this

if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! '))


AH
Creator III
Creator III
Author

Hi Colin,

Anything greater than 1 is showing 'TROUBLE' but whaen its equl to 3 thenit should be showing 'Warning'

Thanks,

Ahmed

maxgro
MVP
MVP

If(Today()-[DAX Service Order Created Date] >3, 'Trouble',

If(Today()-[DAX Service Order Created Date] =3, 'Warning',

  'All Is Good'

)) as Expression

Colin-Albert

This should work

if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

LOAD

*,

If(Today()-[DAX Service Order Created Date] =3, 'Warning',

If(Today()-[DAX Service Order Created Date] >3, 'Trouble',

If(Today()-[DAX Service Order Created Date] <3,  'All Is Good', 'Not Available'

))) as Category

Hope this helps you.

Regards,

Jagan.

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Does [DAX Service Order Created Date] contain a time component? If so, then you will need something like

if (Today()-Floor([DAX Service Order Created Date]) = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein