topic color coding for table in QlikView

color coding for table

yogitamehta10 — Mon, 20 Nov 2017 15:25:22 GMT

HI ALL,

i was writing this expression for color coding i'm doing something wrong ,value is the Expression Label and my values are in %

if(value<-5,RED(),
If(value<=-5 and TS% <=-2.5 ,RGB(255,99,71),
if(value<=-2.5 and value<0.5,RGB(205,92,92),
if(value<= -0.5 and value<0.5,
RGB(255,255,255),
if(value <= 0.5 and value <2.5,RGB(154,205,50),
if(value <= 2.5 and value <5,RGB(127,255,0),
if(value > 5,RGB(0,128,0))))))))

TIA

Re: color coding for table

sunny_talwar — Mon, 20 Nov 2017 15:39:57 GMT

What is wrong with it?

Re: color coding for table

yogitamehta10 — Mon, 20 Nov 2017 16:24:09 GMT

it seems to be some issue

Re: color coding for table

sunny_talwar — Mon, 20 Nov 2017 16:25:15 GMT

Hahaha what is the issue Yogita?

Re: color coding for table

yogitamehta10 — Mon, 20 Nov 2017 16:50:34 GMT

I meant is my syntax right ?because it shows error in expression.

Re: color coding for table

sunny_talwar — Mon, 20 Nov 2017 16:57:42 GMT

Don't see an issue with the syntax, not sure if TS% is needed or not, but that is the only thing which seems little out of line...