Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

"Others" Dimension in Pie chart

Hello All,

I have a requirements that the top 10 dimensions (sorted by sales) in a pie chart show with different colors. Remaining other dimensions (NON TOP 10) should show in one pie slice using single color.

I can color different pie slices from the back groud expression, but I need a dynamic solution. Also the top 10 dimensions of today, may not be top 10 for tomorrow.

Any thoughts?

Or will I have to go the calculated Dimensions way?

Thanks

Raghu

1 Solution

Accepted Solutions
Highlighted

Re: "Others" Dimension in Pie chart

HI

Try like this

Use Dimension limit,

- Show only

Largest - 11

And select Show others option

In Sort tab,

Sort by

Y- Value -> descending

Hope it helps

View solution in original post

1 Reply
Highlighted

Re: "Others" Dimension in Pie chart

HI

Try like this

Use Dimension limit,

- Show only

Largest - 11

And select Show others option

In Sort tab,

Sort by

Y- Value -> descending

Hope it helps

View solution in original post