Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Expression Help

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

1 Solution

Accepted Solutions
tmumaw
Specialist II
Specialist II
Author

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

View solution in original post

2 Replies
tmumaw
Specialist II
Specialist II
Author

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

buzzy996
Master II
Master II

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.