Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get total of some fields data values from pivot table

Hi,

I am new to qlikview and i'm stuck here

my problem is:

here product and Time are dimension and A,B,C etc are the values under Product field.

here i want one new row at the end, named "Total" that contains Sum of C,D,E only.

Problem1.jpg

5 Replies
Anonymous
Not applicable
Author

Load this as a Cross Table in your data model and you can play around with the tables

kiranmanoharrode
Creator III
Creator III

hi ravi there  is option in Presentation tab..

use Totals Option

Capture.JPG.jpg

Gysbert_Wassenaar

Create a new field in the script

ReportProduct:

load * inline [

ReportProduct, Product

A, A

B, B

C, C

D, D

E, E

F, F

Total, C

Total, D

Total, E

];

The use ReportProduct as dimension in your chart instead of Product. You'll see a new value Total that will show the summed values of C, D and E.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi,

Add below script in your expression,

If(Dimensionality()=0, Sum({<Product={"C","D","E"}>} Value), Sum (Value))

Check Show Partial Sum on Product in Presentation tab

partial_sum.PNG.png

Thanks

Anonymous
Not applicable
Author

Please Chek it.

Use the Show Partial sums of some fields...

1.png