topic Re: If statement problem in QlikView

If statement problem

AH — Sun, 15 Feb 2015 18:11:33 GMT

Hi,

I have a expression like this:

(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

Re: If statement problem

Colin-Albert — Sun, 15 Feb 2015 18:17:32 GMT

Try this

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

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

Re: If statement problem

AH — Sun, 15 Feb 2015 18:40:39 GMT

Hi Colin,

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

Thanks,

Ahmed

Re: If statement problem

maxgro — Sun, 15 Feb 2015 19:08:06 GMT

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

Colin-Albert — Sun, 15 Feb 2015 19:29:13 GMT

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

Re: If statement problem

jagan — Mon, 16 Feb 2015 03:23:32 GMT

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.

Re: If statement problem

jonathandienst — Mon, 16 Feb 2015 05:26:30 GMT

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