topic Re: Partial Sum in Straight Table in QlikView

Partial Sum in Straight Table

sanketkhunte — Tue, 16 Apr 2013 09:42:22 GMT

Hi,

Can we add / Show Partial sum in Simple table in QV ?

Thanks

Sanket K.

Gysbert_Wassenaar — Tue, 16 Apr 2013 09:58:05 GMT

You can't. Partial sums are only available in pivot tables. In straight charts you can have only one totalling row.

sanketkhunte — Tue, 16 Apr 2013 10:27:59 GMT

Thanks Gysbert.

Tue, 16 Apr 2013 11:21:15 GMT

Hi,

Straight Table does not have that feature. Instead of straight table,use pivot chart.

Only pivot chart object has the feature to expand/collapse the dimensions used in the chart.

Pivot chart has the feature to do partial sum,which sums the values and shows it on collapse.

In straight table, you can have the one consolidated sum of all the values either at the bottom or at the top.
Hope this helps,

Regards,

Snehal Nabar