Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hope this helps
regards
Marco
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.
please close this thread if your initial question is answered.
thanks
regards
Marco
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.