topic Re: Percentages of whole table instead of dimensions in QlikView

Percentages of whole table instead of dimensions

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have the following table:

Length	Waist	30	31	32	33	34	35	36	38	40
32		50% (2 / 4)	67% (2 / 3)	70% (7 / 10)	58% (7 / 12)	60% (6 / 10)	100% (1 / 1)	90% (9 / 10)	0% (0 / 1)	(0 / 0)
34		0% (0 / 1)	40% (2 / 5)	44% (4 / 9)	36% (4 / 11)	40% (4 / 10)	0% (0 / 1)	80% (8 / 10)	67% (6 / 9)	0% (0 / 1)
36		(0 / 0)	(0 / 0)	0% (0 / 1)	0% (0 / 1)	0% (0 / 2)	0% (0 / 1)	0% (0 / 1)	(0 / 0)	(0 / 0)
38		(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	0% (0 / 1)	(0 / 0)

As you can see the percentages are based on the sum next to it, which is amount sold / amount delivered.

I want the percentage to be calculated as the amount sold against the TOTAL amount delivered. Any Idea on how to do this?

Re: Percentages of whole table instead of dimensions

sunny_talwar — Thu, 09 Jun 2016 15:29:37 GMT

May be like this

Sum(Sold)/Sum(TOTAL Delivered)

Re: Percentages of whole table instead of dimensions

Fri, 10 Jun 2016 07:31:33 GMT

Thanks! This sort of works. Problem is, it calculates over everything, not seperated by dimension. For example. As a Dimension I also have customers. Now I need to calculate the totals per customer, not all.

Re: Percentages of whole table instead of dimensions

pho3nix90 — Fri, 10 Jun 2016 08:10:00 GMT

HI Maarten,

Could you please add an example qvw. The data you pasted in your original post is extremely hard to read

Re: Percentages of whole table instead of dimensions

sunny_talwar — Fri, 10 Jun 2016 10:22:17 GMT

Try this:

Sum(Sold)/Sum(TOTAL <Customer> Delivered)