topic Re: YTD Pie Chart in QlikView

YTD Pie Chart

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

sum({<Grouping={'BUSINESS*', 'DATA CENTRE', '*INFR*', 'IT OTHER', 'IT SERVICES', 'PROJECTS'},
Breakdown={'Total YTD'}, Year={'2014'}>} [Metric Value])/sum({<Year={'2014'}>}[Metric Value])

I'm creating a pie chart that is divided into 5 groups. I want to sum their totals (YTD) and divide them by the total 2014 YTD values .

The above formula seems to be giving me between 33-36% for each grouping which is incorrect. Should be between 2% and 50% for each grouping.

Anyone spot something I've done wrong?

Re: YTD Pie Chart

krishna20 — Tue, 13 Jan 2015 13:50:33 GMT

Hi Dave,

Why are you using single quotes at 2014?

Regards

Krishna

Re: YTD Pie Chart

bobbydave — Tue, 13 Jan 2015 13:55:19 GMT

Noted!

I've changed them to double quotes.

Don't think this would impact the end result.

Re: YTD Pie Chart

krishna20 — Tue, 13 Jan 2015 14:02:34 GMT

Hi,

Create a variable for your field as vCurrentYear=Max(year).

Apply your expression like this

sum({<Year={$(vCurrentYear)},Grouping={'BUSINESS*', 'DATA CENTRE', '*INFR*', 'IT OTHER', 'IT SERVICES', 'PROJECTS'},
Breakdown={'Total YTD'}>} [Metric Value])/sum({<Year={$(vCurrentYear)}>}[Metric Value])

Regards

Krishna

Re: YTD Pie Chart

bobbydave — Tue, 13 Jan 2015 15:29:00 GMT

I get 'no data to display'.

The formula does look correct right?

I want to get a percentage of the total YTD values of each group and divide that by the total overall YTD value.

Would my formula above formulate such a result?

Re: YTD Pie Chart

bobbydave — Tue, 13 Jan 2015 15:57:08 GMT

If I create text boxes and put individual values in per group, the correct values are going in.

However if I put them in as a whole, they all come out as 100% each.

Re: YTD Pie Chart

Tue, 13 Jan 2015 16:10:52 GMT

According to this:

bobbydave wrote:

I'm creating a pie chart that is divided into 5 groups. I want to sum their totals (YTD) and divide them by the total 2014 YTD values .

You're probably missing the Breakdown={'Total YTD'} in the divider:

[...] /sum({<Breakdown={'Total YTD'}, Year={$(vCurrentYear)}>}[Metric Value])

Re: YTD Pie Chart

bobbydave — Wed, 14 Jan 2015 08:19:13 GMT

I just needed to make individual Grouping expressions.

I was trying to create 1 expression with the groupings in this expression.

Instead I created individual expressions and issue resolved.