topic Re: Background color expression in QlikView

Background color expression

Mon, 24 Mar 2014 14:18:03 GMT

Hi All,

I am creating a Projects Management Dashboard and for some reason I cannot get the background colors working when the expression looks like this

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0)),
IF(STATUS = 'Not Started' OR STATUS = 'In-Progress AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0)),
IF(STATUS = 'In-Progress', RGB(0,255,0)

Am I missing something or can I get the colors with a different method?

Thank you.

Re: Background color expression

SunilChauhan — Mon, 24 Mar 2014 14:19:15 GMT

it better to post a sample for us.

Re: Background color expression

Nicole-Smith — Mon, 24 Mar 2014 14:22:05 GMT

You have some parentheses in the wrong places. Corrected formula (for syntax errors anyway):

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0),

IF(STATUS = 'Not Started' OR STATUS = 'In-Progress AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0),

IF(STATUS = 'In-Progress', RGB(0,255,0))))

Re: Background color expression

sudeepkm — Mon, 24 Mar 2014 14:23:47 GMT

IF((STATUS = 'In-Progress' AND Now() = QTR_END) OR (STATUS = 'Not Started' AND Now() > Project_Due_Date), RGB(255,255,0),
IF((STATUS = 'Not Started' OR STATUS = 'In-Progress) AND (Now() > QTR_END OR Now() > Project_Due_Date), RGB(255,0,0),
IF(STATUS = 'In-Progress', RGB(0,255,0))))

Re: Background color expression

its_anandrjs — Mon, 24 Mar 2014 15:36:42 GMT

Hi,

Use some thing like

IF(STATUS = 'In-Progress' AND Now() = QTR_END OR STATUS = 'Not Started' AND Now() > Project_Due_Date, RGB(255,255,0),

IF(STATUS = 'Not Started' OR STATUS = 'In-Progress' AND Now() > QTR_END OR Now() > Project_Due_Date, RGB(255,0,0),

IF(STATUS = 'In-Progress', RGB(0,255,0))))

You miss the single code in field STATUS

Hope this helps

Thanks & Regards

Re: Background color expression

Fri, 11 Apr 2014 15:07:08 GMT

I tried all these but it does not work even though there is no error in the script. Thanks for responding. I am still trying to get it to work.

Re: Background color expression

Anonymous — Fri, 11 Apr 2014 16:20:42 GMT

Regardless the syntax and logic, I have a problem with

Now() = QTR_END

Now() is a timestamp, not a date. This condition is virtually impossible to meet. Maybe you mean

Today() = QTR_END

Re: Background color expression

Fri, 11 Apr 2014 16:36:19 GMT

Yes Michael, you are correct. Now() is always changing so can't use in if condition.