Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

clickertape
New Contributor

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
Honored Contributor III

Re: Summary values when grouping data

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

qv_testing
Valued Contributor

Re: Summary values when grouping data

PFA,

shiveshsingh
Honored Contributor

Re: Summary values when grouping data

Capture.JPG

Put one expression as summary

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

Community Browser