topic Re: Donut Chart(Pie) in QlikView

Donut Chart(Pie)

QVnewbie — Sat, 16 Nov 2024 20:55:39 GMT

Hi everyone,

I have a donut pie chat, that shows simply one category of Count 'Open'/'Closed' in a table.

Problem is instead of showing Total Open and Total Closed as it is, I need it show as below logic:

Closed vs (Open + Closed) x 30%, so that my donut demonstrate the progress to close 30% of total cases, so eventually my donut chart will become just one color when Closed exceeds 30% of total.

When I write it out in the chart expression, the chart displayed Open + 130% Closed, over inflating Closed by 30%.

=(Count([Open Status] = {'Open'}>} [counting])

+ Count([Open Status] = {'Closed'}>} [counting]))*0.3

+Count([Open Status] = {'Closed'}>} [counting])

I have been scratching my head on this for days, I think the answer might be either very simple or impossible, could anyone please help me to get it straight!

thanks, Gavin

Re: Donut Chart(Pie)

Anil_Babu_Samineni — Tue, 07 May 2019 04:31:15 GMT

Perhaps this?

=((Count([Open Status] = {'Open'}>} [counting])

+ Count([Open Status] = {'Closed'}>} [counting]))*0.3)

+Count([Open Status] = {'Closed'}>} [counting])

Re: Donut Chart(Pie)

jaibau1993 — Tue, 07 May 2019 07:07:24 GMT

Hi!

If I understood what you want to achieve then yes, it its possible to be done either using a pie chart or, better, a gauge chart. I attached a file with two examples. Hope it helps!

Jaime.

Re: Donut Chart(Pie)

QVnewbie — Tue, 07 May 2019 11:14:24 GMT

Thanks Loveisfail, unfortunately this didn't work for me, the result is still
130% closed + 100% open on the pie chart.