Discussion Board for collaboration related to QlikView App Development.
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?
You can use Partial Sum in pivot table to have sub totals, please elaborate in which chart you are trying this?
PFA,
Put one expression as summary
aggr(sum(value),[order no])