Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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])