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

[#1]

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

[#2 · Accepted solution]

You can write custom color expression for each expression.

[#3]

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]

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]

Try an expression similar to this:

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

[#6]

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