Total value in a Pivot table by Set Analysis

Wed, 02 Feb 2011 15:36:19 GMT

Hi everyone,

I havea table like this

Country	Month	Sales
Spain	1	45
Germany	1	32
Italy	1	22
France	1	10
Spain	2	12
Germany	2	34
Italy	2	21
France	2	11
Spain	3	8
Germany	3	32
Italy	3	12
France	3	10

and I´d like to made a Pivot Table with Country and Month like Dimensions and SUM(Sales) in Expression, it is easy but also I´d like to add another Expression where I could see the Total Sales of every Month in every row for every Country.

I mean, I´d like to get something like this.

For Example, if Month='1' the Total Sales is '109' so I´d like to get this value an put it in a new column for every row.

Month	1	1	2	2	3	3
Country	Sales	Total Sales	Sales	Total Sales	Sales	Total Sales
France	10	109	11	78	10	62
Germany	32	109	34	78	32	62
Italy	22	109	21	78	12	62
Spain	45	109	12	78	8	62
Total	109	109	78	78	62	62

Maybe it could be possible to do by Set Analysis in the new column, but the problem is that in my pivot table has two dimensions (Country and Month) and I have to try to avoid the Country Dimension to get the right value isn,t it?

Thanks a lot

Total value in a Pivot table by Set Analysis

Wed, 02 Feb 2011 17:14:08 GMT

Hi Eduardo,

In the second expression "Total Sales", you try this code.


Sum(Total <Month> Sales)

Total value in a Pivot table by Set Analysis

Thu, 03 Feb 2011 09:19:56 GMT

Thanks a lot !!!

topic Total value in a Pivot table by Set Analysis in QlikView

Total value in a Pivot table by Set Analysis

Total value in a Pivot table by Set Analysis

Total value in a Pivot table by Set Analysis