If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to format my pivot table in Qlik Sense the way I'd do it in Excel, by color-scaling a set of values based on the range of values.
I have managed to do something like
if([Quotability] <= 0.35, red(), if([Quotability] > 0.35 and [Quotability] <=0.75, yellow(), green()))
but I would like a "smarter" formula, maybe based on quartiles instead of predetermined values.
Does anyone know how to do this?
There is a colourmix() function that can be used. if you have qlikview, there is a wizard for this as writing it directly would not be advised, can produce some nice results.
View solution in original post
Thank you so much, it worked perfectly!