topic Re: IF statement in QlikView

IF statement

Sun, 14 Sep 2014 19:54:40 GMT

Hello,

I am trying to display color in the column when a certain condition is met. I have the following IF statement in the Background Color in the Expression tab of the Chart Properties.

My condition is

If the status is Not Started and the Quarter has passed then display Red.

My IF statement is

IF(Status = 'Not Started' AND Now() > End_Quarter, RGB(255,0,0))

This does not give me the desired results.

I also have another condition

If Status is Started and End Quarter has passed and there is no Completion Date then display Red.

Any suggestions?

Thanks.

Re: IF statement

ecolomer — Sun, 14 Sep 2014 20:04:19 GMT

Two comments:

- are you sure intern format for Now() > End_Quarter, both in Date Format?

- the beguining of expression with a =

Re: IF statement

Sun, 14 Sep 2014 20:19:06 GMT

Thanks for your response.

I did have the = before the expression.

My End_Quarter is 1,2,3,4, TBD etc.

I have the quarter as 1 which in date should be Mar 31, 2 which in date should be June 30 and so on.

Can you please suggest on how to get this working?

Thanks.

Re: IF statement

antoniotiman — Sun, 14 Sep 2014 20:20:19 GMT

You try to use Today() instead of Now()

Regards,

Antonio

Re: IF statement

MarcoWedel — Sun, 14 Sep 2014 20:22:21 GMT

Hi,

should work like you intended:

hope this helps

regards

Marco

Re: IF statement

Sun, 14 Sep 2014 20:24:47 GMT

I tried Today and Now, same result, not the desired result. I think it is because of the format. How can I fix it? Thanks.

Re: IF statement

MarcoWedel — Sun, 14 Sep 2014 20:30:59 GMT

combination of your first and second condition:

hope this helps also

regards

Marco

Re: IF statement

antoniotiman — Sun, 14 Sep 2014 20:38:08 GMT

If your End_Quarter = 'Mar 31' or 'June 30' You use

Date(Today(),'MM/DD') > Date(Date#(End_Quarter,'MMM DD'),'MM/DD')

Re: IF statement

Sun, 14 Sep 2014 20:51:10 GMT

Hi Marco,

Thank you for the help, I am trying to work with your example.

Since, I have the End_Quarter as a number 1, 2, 3 ,4, does that compare to Now()?

Thanks.

Re: IF statement

davidwhite — Sun, 14 Sep 2014 21:36:21 GMT

It is best to not use Now() as it recalculates every second. Use Today().

Re: Re: IF statement

MarcoWedel — Sun, 14 Sep 2014 22:28:51 GMT

hope this helps

regards

Marco

Re: IF statement

Thu, 18 Sep 2014 00:57:43 GMT

Thank you all for your help.

I am still working on this so I need to add to the same column,

If Status = In Progress, display the color green.

Is it possible to create an IF statement with 2 conditions in QlikView?

Thanks.

Re: IF statement

MarcoWedel — Thu, 18 Sep 2014 07:28:32 GMT

please close this thread if your initial question is answered.

thanks

regards

Marco

Re: IF statement

Thu, 18 Sep 2014 13:40:22 GMT

Thanks for your help, Marco.

I am looking to add one more condition on the same column. I tried adding it and the expression is OK but then it displays all status' as green.

If Status = In Progress, display the color green.

IF(Status = 'In-Progress', IF(Status = 'Not Started' and Div(Month(Now())+2,3) > QTR_END or

Status = 'Started' and Div(Month(Now())+2,3) > QTR_END and IsNull(COMPLETION_DATE),

RGB(255,0,0), RGB(0,255,0)))

Thanks.