How to conditionally colour a pivot table in Qlik Sense?

[#1]

Hi,

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?

Thanks,

M.

[tcullinane · Accepted solution]

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.

[#3]

Thank you so much, it worked perfectly!