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: 
clickertape
Contributor II
Contributor II

Summary values when grouping data

how do i get summary values shown in a table?

i.e.

i want to show information for a range or customer order numbers, each of which has more than one line.

i want to see...

order no - part no - qty - price - value

1               1            1       2.0     2.0

1               2            2       3.0     6.0

summary 8.0

2               1             1      2.0     2.0

summary 2.0

etc.

is this possible?

3 Replies
Digvijay_Singh

You can use Partial Sum in pivot table to have sub totals, please elaborate in which chart you are trying this?

qv_testing
Specialist II
Specialist II

PFA,

shiveshsingh
Master
Master

Capture.JPG

Put one expression as summary

aggr(sum(value),[order no])