topic Relative in Pie chart in QlikView

Relative in Pie chart

ariel_klien — Thu, 16 Jan 2014 11:09:40 GMT

Hello all

I have a pie chart and I want to show relative without legend.

all working fine until I have 2 small values.

when I have 2 small values the presents is one on top the other one.

any idea how to resolved it?

maybe discard all the presents that below 3%. - how to do that?

I attached a sample qvw.

Ariel

sundarakumar — Thu, 16 Jan 2014 11:14:20 GMT

Hi Ariel,

You can limit the dimension as below

-Sundar

ariel_klien — Thu, 16 Jan 2014 11:18:38 GMT

Hii Sundar

Thanks for the Quick answer.

it fixed the pie but when i put on the legend the small values are showed as Others... and not the same name they have.

Ariel

sundarakumar — Thu, 16 Jan 2014 12:08:46 GMT

It will just sum the excluded (small) values and will display it as others.

If you dont want to see them you can uncheck "show others" option in the dimension limits tab,

or you can gice any other name to the "others" as shown below,

as these small values are not represented in the graph, you can never have a legend for them.

either you can show them as others or dont show them at all or show them with some generic name like "other minimal entries".

-Sundar

ariel_klien — Mon, 20 Jan 2014 07:46:53 GMT

Thanks,