topic Total Avarage in QlikView

Total Avarage

Thu, 14 Jan 2010 09:11:03 GMT

Hi,

I am new in QlikView, so I would likt to have some help with the total avarage in a straight table. For now I the table is look like this:

Question	Area	Avarage
		Total : 65
Question 1	Area 1	67
Question 1	Area 2	69
Question 1	Area 3	60

But I want to have the table which look in this way:

Question	Area	Avarage

Question 1	Area 1	67
Question 1	Area 2	69
Question 1	Area 3	60
Total		65
Question 2	Area 1	74
Question 2	Area 2	80
Question 2	Area 3	75
Total		71

could anyone please help me with this? (sorry for my english)

Thank you in advance!

Best regards

Malin

Total Avarage

Thu, 14 Jan 2010 09:50:00 GMT

Make sure the chart is a Pivot Table
Go to the chart Properties and then the Presentation tab
Set 'Show Partial Sums' on the Question and Area fields

Note: This will give you an overall average for both questions, as well as an average for question 1 and question 2.

Total Avarage

Thu, 14 Jan 2010 09:58:54 GMT

Thank you very much for your help I appreciate your quick answer.

best regards

Malin

Total Avarage

Tue, 19 Jan 2010 11:37:35 GMT

One more thing Malin, Whenever you make any reports, make it a combo chart with pivot table and straight table as Fast change types. By doing this you caan show partial sums .