Coloring Fields Depending on a Value

[ryanfoster84]

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]

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

[ryanfoster84]

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]

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]

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