topic Re: How to display tow values to use A Donut Chart in QlikView

How to display tow values to use A Donut Chart

Mon, 27 Jun 2016 11:06:03 GMT

Hi, I would like to ask you for help.

I want to make a Donut Chart, such as the following

How can I make it?

Thank you so much for help!

Re: How to display tow values to use A Donut Chart

aapurva09 — Mon, 27 Jun 2016 13:01:14 GMT

Hi,

As we know that pie chart can have only one measure, we can't achieve your requirement using a single chart. Hence a solution can be to use 2 pie charts and overlap them. I have attached an example.

Thanks

Re: How to display tow values to use A Donut Chart

Anonymous — Mon, 27 Jun 2016 13:05:58 GMT

You can just use a pie chart using year as the dimension and then go to the style tab of the chart properties and choose your desired pie chart from the options listed.

Kindest regards

Brian

Re: How to display tow values to use A Donut Chart

Anonymous — Mon, 27 Jun 2016 13:38:12 GMT

try this .

CrossTable(year, Sales)

LOAD * INLINE

[

AREA, 2016, 2017

area1, 20, 4

area2, 12, 14

area3, 25, 30

]

;

FYI ..I have attached do-nut chart as well

Re: How to display tow values to use A Donut Chart

Tue, 28 Jun 2016 01:03:08 GMT

Thank you for your advice.

This chart needs tow measure.
Probably QV make one Circle for year and another Circle for area.
But I want to make one Circle for 2016 and another Circle for 2017.

It's difficult for me....

Thanks.

Re: How to display tow values to use A Donut Chart

Tue, 28 Jun 2016 01:20:41 GMT

Thank you for your advice.

Ｉreally want to make what you suggest!

Unfortunately, My QV is personal edition. so I can't see your file.

I load CrossTable you show me.
and I set [year , sales] for measure.
But QV make one Circle for year and another Circle for area.

Please tell me where Ｉmistake.

Thanks a lot.

Re: How to display tow values to use A Donut Chart

Anonymous — Tue, 28 Jun 2016 07:25:19 GMT

I have inserted video in powerpoint 2013 , please open it and it will show how to allign the variables to DIMENSION and EXPRESSSION

Re: How to display tow values to use A Donut Chart

Thu, 30 Jun 2016 01:45:51 GMT

I posted a reply for you at june 26.
But it's missing.

I tried your suggestion and I made what I want.

Thank you so much for your help.

Re: How to display tow values to use A Donut Chart

Thu, 30 Jun 2016 01:52:46 GMT

Dear Alluraiah Allu.

You are so kindly.

I'll try your suggestion.

Thank you so much!

Re: How to display tow values to use A Donut Chart

soniasweety — Wed, 10 Jan 2018 07:38:58 GMT

very nice