Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

How to color chart by measures. (2 measures)

Dear Team,

Please help me. I have two measures & one dimension.

I want to color completed as green and not started as red.

Thanks.

xxx.PNG

3 Replies
krishna789
Contributor

Re: How to color chart by measures. (2 measures)

HI ahamd  albab,

create master measure for each measure and set color for each master measure and darg master measure to chart.

onur0707
New Contributor III

Re: How to color chart by measures. (2 measures)

Hİ Ahmad,

if you add Completed/NotStarted parameter as a second dimension, you may change the color of the Completed/NotStared parameters like below;

if(Dimension='Completed', green(),

if(Dimension='NotStared',red()))

Add above code to the color by expression tab. you may also use rgb code instead of green()/red() function.

regards;

OY

jubarros
Contributor II

Re: How to color chart by measures. (2 measures)

Hello:

In this case, I use the expresion to calculate the color, for example:

if(COMPLETED_EXPRESSION>0, GREEN(), RED())

It's necesary that the expressions are complementary.

Best Regards.

Community Browser