Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can write custom color expression for each expression.
You can write custom color expression for each expression.
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
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.
Try an expression similar to this:
if(Measures='Actual', Green(), if(Measures='Budget', Blue(), Grey()))
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')