Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Add a Total Value to the Pivot Table

Hi All,

I have a created a pivot table from a excel list.

How to add a value called 'Total" to the "Base" column which is the total of all G-Codes of a Base.

In the sample for base value "A" the Total is 11.

or

How to calculate the sum of the individual G-Codes?

Q.JPG

Thanks!

Praveen.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Add a Total Value to the Pivot Table

Go to the tab presentation and on the top left area you could enable the totals for each single dimension.

ps: Please do not double/triple posting.

- Marcus

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Add a Total Value to the Pivot Table

Go to the tab presentation and on the top left area you could enable the totals for each single dimension.

ps: Please do not double/triple posting.

- Marcus

View solution in original post

Highlighted
Partner
Partner

Re: Add a Total Value to the Pivot Table

In the presentation tab tick the "show partial sums" option for each dimension and expression.

regards,

Asmita

Highlighted

Re: Add a Total Value to the Pivot Table

Marcus, Sunny and me are getting the impression that the multiple posts of the exact same question is not intentional. Most of these double posts have sequential IDs and are at most minutes apart. Also, almost all of them are posted in one and the same forum (we've assembled a list of more than 30 similar cases)...

Praveen, were you experiencing delays when you first pressed the "Post" button? Did you click it multiple times because there was no reaction from the Community site?

Highlighted
Contributor III
Contributor III

Re: Add a Total Value to the Pivot Table

Hi Peter,

There was a delay when I tried to post the question.