Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to set custom colors by measure in a Trend Analysis?

Hi,

I am kind of new to Qlik Sense, I am trying to set different colors( Blue, Green, and Grey) to 3 different measures ( Budget, Actual,and Forecast).

My measures are: Budget, Actual, and Forecast

My dimension is: Month/Year Period --> i.e.( Jan 2015)

I would like to create an expression where I indicate Budget = Blue, Actual= Green, and Forecast= Grey.

Could someone assist me or give me any tips on how to create a expression for this type of case?. Thank you in advance.

Best regards,

TV

1 Solution

Accepted Solutions
Not applicable

Re: How to set custom colors by measure in a Trend Analysis?

You can write custom color expression for each expression.

5 Replies
Not applicable

Re: How to set custom colors by measure in a Trend Analysis?

You can write custom color expression for each expression.

Not applicable

Re: How to set custom colors by measure in a Trend Analysis?

I already tried to write a custom color expression for each expression but it didnt work.

if (Measures=Budget ,'blue') ,

if (Measures=Actual ,'green') ,

if (Measures=Forecast ,'grey')


Could you please let me know why I am getting an error  in my expression? Thank you in advance.


Best,


TV

sll
New Contributor III

Re: How to set custom colors by measure in a Trend Analysis?

Try an expression similar to this:

if(Amount='Actual', Green(), if(Amount='Budget', Blue(), Grey()))

Make sure you check "The expression is a color code" checked.

sll
New Contributor III

Re: How to set custom colors by measure in a Trend Analysis?

Try an expression similar to this:

if(Measures='Actual', Green(), if(Measures='Budget', Blue(), Grey()))

Not applicable

Re: How to set custom colors by measure in a Trend Analysis?

Hi,

You can read about this is the Qlik Sense Comprehensive Developer Tutorial.

Qlik Sense Comprehensive Developer Tutorial

Try this expression:

pick(match ("Columnname", 'measure'), 'steelblue')