topic Re: Error in cumulative sum calculation. in QlikView

Error in cumulative sum calculation.

Anonymous — Tue, 05 Dec 2017 10:43:39 GMT

Hello there,

So i have a QlikView application that calculates and predicts Cash Flow values.

The application is created in QlikView Desktop and then it is uploaded in a custom ERP program.

The problem i am facing (see below for the images) is that in a field where it holds the progressive cumulative sum of some values although i get the correct result in the QlikView Desktop, when i upload it in the ERP it damages the calculation.

The reason for that is that the yesterday the ERP had an update and it seems that some functions has not been set correctly.

So, my question is:

Does anybody have any idea of a workaround for the aformentioned problem?

This is the correct result as shown in th QlikView Desktop

The code behind it is:

if(

Dimensionality()=0,

/*then*/ rangesum(before(column(1),1,1)),

/*else*/ 0

)

The result i am getting in the ERP is:

Any help will be highly appreciated.

Thank you.

Re: Error in cumulative sum calculation.

Gysbert_Wassenaar — Wed, 06 Dec 2017 09:10:32 GMT

Use Qlikview instead of your broken custom ERP system?

Re: Error in cumulative sum calculation.

Anonymous — Wed, 06 Dec 2017 09:13:14 GMT

How do you mean that?

The QlikView App must be uploaded in the ERP system and the question refers to an alternate way to calculate the cumulative sum.

Re: Error in cumulative sum calculation.

Gysbert_Wassenaar — Wed, 06 Dec 2017 10:22:56 GMT

Why? The calculation in Qlikview is correct. You're ERP was updated and now it shows incorrect results. Ergo, your ERP system is broken. I doubt the solution is to create incorrect calculations in Qlikview.

Re: Error in cumulative sum calculation.

Anonymous — Wed, 06 Dec 2017 10:40:49 GMT

I know that the calculation in QlikView is correct.

I am asking for an alternate way to get the similar output in QlikView in order to upload it in the ERP. The reason that the ERP is showing incorrect results is because the update has not took into consideration certain functions (rangesum() combined with the before()).

To be clear:

The aformentioned calculation is correct (i tested it several times). If you know a different way to get the same result in QlikView please do tell.

Thank you.

Re: Error in cumulative sum calculation.

Gysbert_Wassenaar — Wed, 06 Dec 2017 16:41:33 GMT

What exactly do you upload into your ERP system? An excel export of the pivot table from the .qvw file?

Re: Error in cumulative sum calculation.

Anonymous — Wed, 06 Dec 2017 21:10:36 GMT

No. The images are just an image of the whole document. Due to sensitive data i didn't uploaded the whole application.

In the ERP I upload the whole QlikView document (.qvw file) as it is created in the QlikView Desktop.