Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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.

View solution in original post

Not applicable
Author

Thank you so much, it worked perfectly!