topic Re: I am using "Color by expression" but the graphics are gray in App Development

I am using "Color by expression" but the graphics are gray

wisetrackchile — Sat, 16 Nov 2024 09:30:18 GMT

Hi,

Please help me:

I am using "Color by expression" but the graphics are gray

The Dimension:

=if((DRIVERTIME < 341),'LOW',

if((DRIVERTIME >= 341) And (DRIVERTIME < 361),'MEDIUM',

if((DRIVERTIME >= 361),'HIGH')))

The Measure:

=Count(TRIPS)

Color by expression:

=if((DRIVERTIME < 341),Green(),

if((DRIVERTIME >= 341) And (DRIVERTIME < 361),Yellow(),

if((DRIVERTIME >= 361),Red())))

THANKS!!

Re: I am using "Color by expression" but the graphics are gray

Anonymous — Thu, 20 Jul 2017 20:12:35 GMT

I would suggest finding the RGB value of the colour and using that e.g.

if("Gender"='Male',rgb(68,119,170),if("Gender"='Female',rgb(204,102,119), rgb(253,219,102)))

Re: I am using "Color by expression" but the graphics are gray

wisetrackchile — Thu, 20 Jul 2017 20:15:55 GMT

Bella, thanks

I also tried that option, but it does not work either

Rodrigo

Re: I am using "Color by expression" but the graphics are gray

rwunderlich — Fri, 21 Jul 2017 06:14:12 GMT

Because the color expression is calculating over multiple rows, you must do some sort of aggregation over DRIVERTIME. As you have it now in the IF(), DRIVERTIME will return null when there are multiple rows. Try using "Avg(DRIVERTIME)" in your color expression.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: I am using "Color by expression" but the graphics are gray

prithviram777 — Fri, 21 Jul 2017 11:16:58 GMT

Please check if this might be the reason.

Are you using alternative dimension?

Re: I am using "Color by expression" but the graphics are gray

wisetrackchile — Fri, 21 Jul 2017 13:00:57 GMT

Eureka !!! That was the problem, thank you very much!!!

Re: I am using "Color by expression" but the graphics are gray

prithviram777 — Fri, 21 Jul 2017 13:05:35 GMT

If you found the document clip useful, please mark my response as correct or appropriate.

Thank you

Re: I am using "Color by expression" but the graphics are gray

mjtaft2017 — Mon, 24 Jul 2017 18:40:52 GMT

Please mark Rob Wunderlich's response as correct since you indicated that resolved your question. I selected this question because it was still marked as unanswered - but upon reading it, you did get a correct response and it just needs to be marked.

Thank you.