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.
Solved! Go to Solution.
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.
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.
You can read about this is the Qlik Sense Comprehensive Developer Tutorial.
Try this expression:
pick(match ("Columnname", 'measure'), 'steelblue')