Pie Chart slices limit option option required in Ver 11 of QV

[rajtechnocraft]

Hi Experts,

Needed help onpie chart formatting

I am using ver 11

Problem is i am having lot of regins in my dimensions .So i want to limit them to top 5 and group the remaining in others

Previous in ver 9 in Presentation tab there using to be lower limit of number of slices to be shown

But i don't find this option anymore

Can you pls help me how to restrict the number of slices in pe chart

Regards

Arvind

[kaushiknsolanki]

Dear Raj,

     You can go to dimension limit and set your limit, Say top 5 and then click on the others.

     This will show you top 5 Regions and one more pie for others.

Regards,

Kaushik Solanki

[Gabriel]

Hi,

Your best bet is to go to properties and activate Demension Limit tab check the check box before Restrict Which Values are Displayed...

And check the radio box for Show only and enter 5 in thte box (or appropraite number)

Regards,

Gabriel

[advait_thakur]

Hi there,

We do not have option of Min and Max slicing in Pie Chart (Qlikview Version 11)

In Qlikview 11, we have new feature of Dimension Limit where you can set the limit.

This option was there in presentation tab in Version 9 & 10 where user can limit the dimension.

Hope this is useful to you.

Thanks

Advait

[rajtechnocraft]

Hi Kaushik,

I did this but the other category  in legend  i am not able to drill down further

I went to dimension tab

Selected option show only

Largest

Cretaed a Top variable   and passed the value 5

It shows 5 lices and other category but when i click on category it doesn't drill down further

How can i achieve this

Regards

Raj

[rajtechnocraft]

Hi Kaushik,

I did this but the other category  in legend  i am not able to drill down further

I went to dimension tab

Selected option show only

Largest

Cretaed a Top variable   and passed the value 5

It shows 5 lices and other category but when i click on category it doesn't drill down further

How can i achieve this

Regards

Raj

[kaushiknsolanki]

Hi,

     Have a look at the attachment. I am able to drill down through the other.

Regards,

Kaushik Solanki

[#8]

Dimension limit beside Dimensions tab has the pie slicing restricting option.

Solution form Kaushik works like a charm