topic Re: Totals on Horizontal Axis - Pivot Table in QlikView

Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 12:21:05 GMT

Hello

I have a pivot table which has 4 dimensions and 1 expression

I have used partial sums to get a total along the vertical side of my table, however I want to show a total on the horizontal of my table

Can anyone help me to achieve this?

Many Thanks

Helen

Re: Totals on Horizontal Axis - Pivot Table

kaushiknsolanki — Mon, 22 Jul 2013 12:29:17 GMT

Hi,

Hele,

Check the partial sum option for all dimensions. or the dimension which you have crossed tabbed (Kept above expression)

Regards,

Kaushik Solanki

Re: Totals on Horizontal Axis - Pivot Table

Mon, 22 Jul 2013 12:37:19 GMT

In presentation tab

select field

Check on show partial sum

Re: Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 12:50:23 GMT

Hello There

Thank you for your response. I have done this and still only get a total along the left hand side

Dimension 1	Dimension 2	Dimension 3	A	B	C	D	Total
							1
							16
							7
							3
							3
							111
							21
							62
							56
							2
							51
							31
							20
							1
							69
							1
							9
							1
							1

Can you help?

Re: Totals on Horizontal Axis - Pivot Table

Mon, 22 Jul 2013 12:53:00 GMT

Hi ,

I have a similar scenario with Helen, see the excel pivot below

I just need check on the partial sum to get sum of the category but I need the cumulative sum of day

for example :

Mon= 2

Tues=2+3

Wed=2+3+0

Thu=2+3+0+1 and so on.

Please help.

Thanks,

Re: Totals on Horizontal Axis - Pivot Table

kaushiknsolanki — Mon, 22 Jul 2013 12:53:24 GMT

Hi,

Go to properties ->Presentation Tab ->Here you have a option Subtotals on Top.

Click on that.

Regards,

Kaushik Solanki

Re: Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 12:57:12 GMT

Hello

Thank you for your advice, but this just moved my total from the back to the front. I ahve tried moving to be horizontal, but can get this to move

Any other ideas?

Thanks

Helen

Re: Totals on Horizontal Axis - Pivot Table

kaushiknsolanki — Mon, 22 Jul 2013 13:01:01 GMT

Hi,

Have a look at the application.

Regards,

Kaushik Solanki

Re: Totals on Horizontal Axis - Pivot Table

Mon, 22 Jul 2013 13:04:06 GMT

Hi Helen,

is it posible to send the Qlikview file?

Re: Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 13:29:22 GMT

Hello

Thanks for this....This works for me

Re: Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 13:29:33 GMT

Hello

Thanks for this....This works for me

Re: Totals on Horizontal Axis - Pivot Table

helen_pip — Mon, 22 Jul 2013 13:29:46 GMT

Hello

Thanks for this....This works for me,

Thanks for your help