Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pie Chart Colour problem

Hi Community,

I am facing a problem in Pie chart.since I am using persistent colour option and there is a repeatition of same colour.As in the colour there are option for only 18 colours but I am having around 45 items to represent and colour is required to be persistent and distint across the application.

Is there any option to represent more than 18 items or expression is the only way ?

Thanks ,

Ravi

1 Solution

Accepted Solutions
MVP
MVP

Re: Pie Chart Colour problem

Agreed.  Also consider building a table with RGB values for each dimension value, then using RGB(R,G,B) as the background color expression.  That will let you have as many colors as you want, and the exact same color for a specific value in every chart, though it may be difficult to make them visually distinct.  See attached example.  It also includes random colors for dimension values that are added to the data set later, and for which you haven't assigned a specific value.

3 Replies
Not applicable

Pie Chart Colour problem

Hi Ravi,

I'm pretty sure we are only limited to those 18 colors. But, as you mentioned, you can specify many more colors through the expression. I've recently had to do that, so if you have a question about how to do that, I can provide some instructions.

In short, expand the Expression, and in "Background Color", based on a logic (like RowNo() for example), define which color to use with the rgb() function.

Hope that helps,

Siarhei K.

MVP
MVP

Re: Pie Chart Colour problem

Agreed.  Also consider building a table with RGB values for each dimension value, then using RGB(R,G,B) as the background color expression.  That will let you have as many colors as you want, and the exact same color for a specific value in every chart, though it may be difficult to make them visually distinct.  See attached example.  It also includes random colors for dimension values that are added to the data set later, and for which you haven't assigned a specific value.

Not applicable

Pie Chart Colour problem

Thanks a lot ! It is working fine .

Community Browser