Set analysis - using sum totals for each year in column

Thu, 17 Oct 2013 11:29:52 GMT

Hi everyone,

I'm starting to learn the set analysis and I'm stuck on using a sum total for each year in a column. Can anyone help me?

What I'm trying to achieve is (to use the simplest example) something like this:

Year Product Quantity Percentage

2007 A 15 17,65%

2007 B 20 23,53%

2007 C 40 47,06%

2007 D 10 11,76%

2008 A 5 33,33%

2008 B 10 66,67%

The percentage is of course the Quantity / Total Quantity per Year and I can't use one variable here because years here are different and first four rows take a sum of Quantity 2007 and fifth and sixth rows take sum of Quantity 2008. I don't know how to achieve that in one table. I'm attaching an qvw and xlsx but an explanation for example as simple as above will suffice I think.

Thanks so much in advance for your help.

Best regards,
Paweł

Re: Set analysis - using sum totals for each year in column

christian77 — Thu, 17 Oct 2013 11:42:18 GMT

Hi:

what you need is the divisor, to be fixed for each year, isn't it?

There it goes...

Re: Set analysis - using sum totals for each year in column

Thu, 17 Oct 2013 11:48:44 GMT

This is exactly what I've been looking for!! Thank you!

topic Re: Set analysis - using sum totals for each year in column in QlikView

Set analysis - using sum totals for each year in column

Re: Set analysis - using sum totals for each year in column

Re: Set analysis - using sum totals for each year in column