topic Re: Columns subtotals in table in QlikView

Columns subtotals in table

Thu, 03 Jan 2013 13:32:00 GMT

Hello

I would like to have a pivot table like this:

	Product A				Product B				Product C				SubTotal	SubTotal
	IN	OUT			IN	OUT			IN	OUT			Product A	Product B + C
	IN	PT	ES	Others	IN	PT	ES	Others	IN	PT	ES	Others
Jan	8	2	1	4	4	2	1	1	4	2	1	1	15	16
Feb	7	4	3	5	1	2	2		1	2	2		19	10
Mar	9	2	2	2	2	1	1	1	2	1	1	1	13	10
SubTotal 1		8	6	11		5	4	2		5	4	2
SubTotal 2	24	25			7	11			7	11
Total	49				18				18				49	36

The dimensions are "Month", "Products", "IN/OUT" and "Countries" and the respective quantities are given by a sum expression.

For now I've managed to do the majority of the table but i'm lacking the experience to do lines and columns in red.

How can I do the SubTotals columns and lines that I've mencioned above?

Thanks in advance

Re: Columns subtotals in table

Anonymous — Thu, 03 Jan 2013 14:03:21 GMT

Presentation sheet of charts properties, select the dimension in the top left and tick the Show Partial sums checkbox below it. Looks like you'd need to do this for the "IN/OUT" and "Countries" dimensions.

Jonathan

Re: Columns subtotals in table

Thu, 03 Jan 2013 14:21:57 GMT

Thanks jonbroughavone.

I've tried to do that but it creates the total line by line and not column by column which means I end up getting:

	Product A						Product B
	IN	OUT				Total	IN	OUT				Total
	IN	PT	ES	Others	Total		IN	PT	ES	Others	Total
Jan	8	2	1	4	7	15	4	2	1	1	4	8
Feb	7	4	3	5	12	19	1	2	2		4	5
Mar	9	2	2	2	6	15	2	1	1	1	3	5
Total	24	8	6	11	25	49	7	5	4	2	11	19

Which is not what I actually want. Is there any flag or option that I have to enable to do what I pretend?

Re: Columns subtotals in table

Anonymous — Thu, 03 Jan 2013 14:46:43 GMT

Not that I know of.

Jonathan