This content has been marked as final. Show 2 replies
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?