Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

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

2 Replies
tcullinane
Creator II
Creator II

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
Author

Thank you so much, it worked perfectly!