topic Re: horizontal cumulation in pivot table in QlikView

horizontal cumulation in pivot table

Tue, 19 Aug 2014 12:41:39 GMT

Hey Guys

I would like to add a column to my pivot table which cumulates the values up to the current month. At this point the table looks like this:

In other words, there should be a Column each time after "IST" that cumulates the "IST" values. Referring to this example it should look like this:

Unfortunately the function Cumulate as well as my set analysis formula isn't working. Could someone please help me with this problem?

regards

Sebastian

Re: horizontal cumulation in pivot table

tresB — Tue, 19 Aug 2014 12:45:43 GMT

Try like:

Cum IST: =RangeSum(IST, before(Cum IST))

Re: horizontal cumulation in pivot table

Tue, 19 Aug 2014 13:03:55 GMT

Hi Tresesco - that worked like a charm, thank you very much!

Re: horizontal cumulation in pivot table

Mon, 15 Sep 2014 10:59:34 GMT

Hi Tedesco,

Unfortunately i found some errors in the calculation:

If you look at the graphik above, all marked rows are being calculated wrong. The second last column (IST kum.) is the calculated cumulative sum (i exported the numbers to excel in order to make it more clear, in the actual report all the cumulative sums are available). The last column is the correct sum calculated in excel.

Has anyone an idea why this formula sometimes works and sometimes not? I couldn't find any patterns...

Thanks,

Sebastian

Re: horizontal cumulation in pivot table

tresB — Mon, 15 Sep 2014 11:16:55 GMT

Try to share your sample qvw that demonstrates the issue. See: Preparing examples for Upload - Reduction and D... | Qlik Community