topic Pie Chart in QlikView

Pie Chart

alibd225 — Thu, 16 Jul 2015 08:08:16 GMT

Hi all, can you help me to create this type of pie chart in Qlikvie

If Higher 5 value are 90, 40 , 30 , 20 , 30 and lower 5 value are 1, 0 .5, 0.7, 0.8 , 0.3 then Qlikview pie chart showing clumsy.

So we need to incorporate this type of chart in Qlikview. Without this type of chart we can’t represent actual scenario of business.

Re: Pie Chart

Gysbert_Wassenaar — Thu, 16 Jul 2015 17:43:10 GMT

See attached example.

Re: Pie Chart

Anonymous — Thu, 16 Jul 2015 18:05:50 GMT

you can show all the values in a single pie chart or the highest of those or the lowest individually, if that is what you are looking for..In dimension limits show the n-highest,n-lowest values.

Re: Pie Chart

alibd225 — Thu, 16 Jul 2015 18:12:56 GMT

thanks. but i want to display in a single chart. in excel there have a chart type where automatically display this type of chart

Yakub

Re: Pie Chart

Gysbert_Wassenaar — Thu, 16 Jul 2015 18:18:07 GMT

Then you'll have to write/code/program an extension object. Or use excel. Qlikview does not has this kind of dysfunctional charts.

Re: Pie Chart

alibd225 — Thu, 16 Jul 2015 18:20:37 GMT

is it possible to use excel in qlikview ? please help me how i can manage it

Re: Pie Chart

Gysbert_Wassenaar — Thu, 16 Jul 2015 18:24:17 GMT

Yes, use the search feature: https://community.qlik.com/search.jspa?q=excel+macro

If you're not a skilled vbscript programmer then give up. You're not going to manage it. And I'm not either.

Re: Pie Chart

Anonymous — Thu, 16 Jul 2015 18:26:17 GMT

Hi,

You can put the two charts in the container and extract the legends and titles.

Re: Pie Chart

MarcoWedel — Thu, 16 Jul 2015 21:54:02 GMT

Hi,

one additional example combining Gysbert's and Mauri's solutions/suggestions:

(But I also don't consider pie charts the best visualizations for this data. )

hope this helps

regards

Marco