• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7517
  • Last Modified:

How do I show pivot tables totals in QlikView ?

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
0
Tocogroup
Asked:
Tocogroup
  • 3
  • 3
1 Solution
 
RobOwner (Aidellio)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)
0
 
TocogroupAuthor 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
0
 
RobOwner (Aidellio)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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TocogroupAuthor Commented:
0
 
RobOwner (Aidellio)Commented:
You need to check the "show partial sums" box for every dimension/expression you want to have a total (top left, just under the last of them)
Also for your expression to show a total it must use a totaling function e.g. SUM etc
0
 
TocogroupAuthor Commented:
That's great. Many thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now