topic Re: pivot table sum before data in QlikView

pivot table sum before data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello,

i have the first table in qlikview, and i would like to get the second one.

¿can you help me?

adityaakshaya — Thu, 08 Mar 2018 20:04:22 GMT

Hi Mark,

you can explore rangesum function in this scenario.

Regards,

Akshaya

sergio0592 — Thu, 08 Mar 2018 20:15:27 GMT

Hi,

You can use rangesum function. See my attached .qvw (i made a new sample because i'am in Personnal edition right now)

Regards

Anonymous — Thu, 08 Mar 2018 20:23:47 GMT

it is writting the sum in places that before there wasn´t any data.

in places where now there is now data, it should be an acummulative sum and stop where there is now data.

sunny_talwar — Fri, 09 Mar 2018 02:12:39 GMT

May be this

If(Sum(V2) <> 0, RangeSum(Sum(V1), Sum(V2)), 0)

If(Sum(V3) <> 0, RangeSum(Sum(V1), Sum(V2), Sum(V3)), 0)