We help IT Professionals succeed at work.

How do I show pivot tables totals in QlikView ?

Tocogroup
Tocogroup asked
on
8,288 Views
Last Modified: 2014-08-14
Hi,

I have a QlikView dashboard with a pivot table object which displays three columns (dimensions) and 2 expression columns. I want to display the totals for each expression column on the first row of the pivot table (after the column headings).

However, even though I've set the 'Subtotals on Top' radio button on the Presentation tab, they aren't appearing in my table. Should I be setting totals on anywhere else ?

Thanks
Toco
Comment
Watch Question

RobOwner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
It's a bit convoluted in that you need to check the show sub totals on the dimension below what you're wanting to show.

If you post a screenshot I'll point out what to do (haven't got qlikview available right now)

Author

Commented:
Hi Rob,

I've attached a screenshot of the pivot table. Not sure if you wanted the Properties pages.

I've simplified the pivot but I just want to show a Totals line above the individual Year rows.

Thanks
QV-Pivot-Table-screenshot.PNG
RobOwner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
Sorry, it was the presentation tab that I needed to see.  I'm home now so i'll fire up Qlikview and take a look
Owner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
That's great. Many thanks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.