Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to conditionally colour a pivot table in Qlik Sense?

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.

1 Solution

Accepted Solutions
tcullinane
Contributor II

Re: How to conditionally colour a pivot table in Qlik Sense?

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.

2 Replies
tcullinane
Contributor II

Re: How to conditionally colour a pivot table in Qlik Sense?

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.

Not applicable

Re: How to conditionally colour a pivot table in Qlik Sense?

Thank you so much, it worked perfectly!

Community Browser