Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Pivot Table Total

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?

7-25-2012 10-52-12 AM.jpg

2 Replies
Not applicable

Re: Pivot Table Total

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

Not applicable

Re: Pivot Table Total

Yes – that worked perfectly. Thanks!

Community Browser