topic Re: Sum Total based on the left columns in QlikView

Sum Total based on the left columns

sijojoseph22 — Tue, 26 Apr 2016 15:24:58 GMT

Hi All,

I need to create a pivot table by adding the sum of months in a accumulative from the left side columns in a pivot table.

Attached the data we are having

Attached the data we are expecting.

Attached the qvw with raw data

Thanks,

Sijo

sunny_talwar — Tue, 26 Apr 2016 15:26:59 GMT

Try this expression:

=RangeSum(Before(Sum(GWP), 0, ColumnNo()))

sijojoseph22 — Tue, 26 Apr 2016 16:21:59 GMT

Thanks Sunny, it is working for me. I will try this in my real dashboard.