topic Re: Combining multiple small data points into one for pie chart in QlikView

Combining multiple small data points into one for pie chart

Fri, 22 Mar 2013 09:46:21 GMT

Hey,

So I've got a database that includes personal issues that people may have (Drugs, drink, etc).

There are some larger ones, but there are also some issues that may only affect one or two people. There's about 6 of them.

I want to combine these smaller issues into one part of a pie chart as "Other".

Would it be a case of something like

if( Count(Personal_Issue) < 2, Personal_Issue as Other)

in the pie chart.

Any help?

Thanks.

Re: Combining multiple small data points into one for pie chart

Gysbert_Wassenaar — Fri, 22 Mar 2013 09:56:34 GMT

If you have QV11 you can use dimension limits and enable the Show Others option. You can find the settings on the Dimension Limits tab of the properties window.

Re: Combining multiple small data points into one for pie chart

Fri, 22 Mar 2013 10:00:12 GMT

Brilliant, thank you