Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm currently working on a food item visualization within Qlik Sense Desktop and I had a question about color coding and string functions. I would like to color every category that costs more than 20M blue. I would like to make everything less than 20M pink. How is this possible in Qlik Sense Desktop using the functions available? I'm attaching a picture of what I have so far (the grey chart). Any help is greatly appreciated and I thank you all for your time!
Sincerely,
Debashish
Hi
in the control panel of your bar chart
in color and legend choose custom color by expression
then
add this :
if(
mymesure < 20 000 000 , rgb(255,82,255),rgb(51,155,255)
)
"mymesure" is the mesure you use in your bar chart
hope it helps
Hi Debashish, the expression from Bruno is correct. You can also go to "Appearance" -> "Colors and Legend" and then Change "Range" from "Auto" to "Custom" and you can add a "Min" and "Max".
Thanks, I'm trying it out right now but I'm still getting an error in my expression as shown here. All your help is appreciated and thanks again!
Hi
Type 20 000 000 rather than 20,000,000
Comma are used as separators in qlik expression
I just tried that and I'm still getting an error. Thanks for the continued help.
Hi Debashish,
no spaces are allowed within the number, so type 20000000 instead of 20 000 000.
hope it helps - for me it did
Harald
Hi
Sorry Harald is right : no space within the number, 20000000 is the good answer
Bruno