Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

AH
Contributor

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 <3 then show 'All is Good'.

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

Thanks,

Ahmed

Tags (2)
6 Replies

Re: If statement problem

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
Contributor

Re: If statement problem

Hi Colin,

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

Thanks,

Ahmed

MVP
MVP

Re: If statement problem

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

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

  'All Is Good'

)) as Expression

Re: If statement problem

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! '))

MVP
MVP

Re: If statement problem

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.

MVP
MVP

Re: If statement problem

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
Community Browser