topic Re: Pivot Table Total in QlikView

Pivot Table Total

Wed, 25 Jul 2012 14:55:46 GMT

Hi! I would like to have the types (recent, inpatient and outpatient) on the horizontal axis at the top and add a total column that counts the number of patients from each country. So for UAE, I want to show Inpatient (5) Recent (15) and Outpatient (23) at the top with a total of 43 on the right hand side. Any ideas?

Re: Pivot Table Total

Wed, 25 Jul 2012 15:08:26 GMT

Hi,

Put your cursor on type and hold right click till a blue line appears, drag the line above MRN Count till it becomes horizontal. Go to Presentation tab click on Country and check the show Partial Totals.

I believe that should lead you to the view you are looking for.

Regards

Rahul

Re: Pivot Table Total

Wed, 25 Jul 2012 16:32:52 GMT

Yes – that worked perfectly. Thanks!