topic Re: Coloring Fields Depending on a Value in QlikView

Coloring Fields Depending on a Value

ryanfoster84 — Fri, 11 Mar 2016 17:46:42 GMT

hi,

i am having an issue with coloring a cell depending on the value

as you can see there are three values - past due, future opp and closing w/in 30 days. so the formula for calculating this is as follows:

=IF([Opportunity Status] = 'Future Opp' , rgb(187,216,84),

IF ([Opportunity Status] = 'Past Due' , rgb(252,115,98), rgb(240,160,80)))

but as you can see it isn't working correctly. any help would be greatly appreciated.

Gysbert_Wassenaar — Fri, 11 Mar 2016 17:58:46 GMT

Can you post a small qlikview document that demonstrates the problem?

ryanfoster84 — Fri, 11 Mar 2016 18:02:20 GMT

i can not as it contains customer information.

but essentially the problem is ifuture opp should be GREEN, Closing within 30 days should be ORANGE and past due should be RED.

you can see from the table this isn't working correctly.

Gysbert_Wassenaar — Fri, 11 Mar 2016 18:27:18 GMT

Get creative. Make something that demonstrates the problem. I don't care what data it contains. I'm not asking for confidential customer information.

Digvijay_Singh — Sat, 12 Mar 2016 14:22:31 GMT

I tried on small sample, its working, I suspect you have some spaces in your 'status' column,might be causing prob in matching.

Load * inline [

Account, OppStatus, Value

Gong, Past Dues, 100

Judge, Future Opp, 200

Stoker, Closing in 30 days,300 ];

the same Bkcolor expression in straight table -

=IF([OppStatus] = 'Future Opp' , rgb(187,216,84),

IF ([OppStatus] = 'Past Dues' , rgb(252,115,98), rgb(240,160,80)))