topic Expression Help in QlikView

Expression Help

tmumaw — Tue, 21 Apr 2015 16:38:34 GMT

Any idea what is wrong with this expression? I keep getting error in expression.

Thanks

if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0)))

Re: Expression Help

tmumaw — Tue, 21 Apr 2015 16:43:35 GMT

Got it.....

if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#))),RGB(255,0,0),RGB(0,0,0)))

Re: Expression Help

buzzy996 — Tue, 21 Apr 2015 16:58:48 GMT

try this,

=if(Sum(UnKnown_Cnt) / count(Empl.#) < 0.20,RGB(0,0,255),

if((Sum(UnKnown_Cnt) / count(Empl.#) ) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0))

check bracket pls.