Discussion board where members can get started with Qlik Sense.
Hi Qlik Techies,
We have a color option (Color by Measure). It gives a the color variation like below I attached,
But my scenario is, instead of the blue I need to change the color as Green. So, it should get varies from green to red.
Is it possible..??
try to create master measure item (here u can easily define the color your value range.)
also you can write if condition like below
if(sum(Sales)>100,rgb(127,255,127),rgb(255,127,127)) //use u r measure field and conditon -- qliksense put this expression in background color expression section
it will give only two colors. But what I need is it should start with green and end with red. The color should be varied based on the value.
you can enable custome colour by dimension
here sometimes dimension will be selected different ---- try to add the dimension which you want
and apply it will work.
ColorMix1 will work perfect for you.
The important part is calculation the borders for which the gurus just need to understand the measures your using to create a representation from 0 to 1.
I hope this helps,
Suggested setting will give different color for each dimension value. when u have issue, better try to prepare some mock app with sample data and highlight your issue so that would be easy for others to check and help you quickly.