topic Re: Help with Pivot Table Results in QlikView

Help with Pivot Table Results

Wed, 25 Nov 2020 16:16:04 GMT

Below is my data and existing qlikview results. I am trying to get the results in the last image below. AR is accounts receivable and I am trying to understand receivable amounts that exist at a certain point in time vs another point in time. Any thoughts on how to do this?

Thanks--Gary

ARHistory:

Load * inline

[

ARDate,MeasureDate,LoanNum,Amount

1/31/17,1/31/17,123,1000

1/31/17,1/31/17,456,800

1/31/17,1/31/17,789,500

2/28/17,2/28/17,123,900

2/28/17,2/28/17,456,400

2/28/17,2/28/17,333,600

];

Existing results below

Below are the results I am wanting

Re: Help with Pivot Table Results

m_woolf — Fri, 29 Sep 2017 10:08:31 GMT

You haven't said what your expression is. It should probably be:

=sum(Amount)

Re: Help with Pivot Table Results

Fri, 29 Sep 2017 21:42:35 GMT

=sum(Amount) is expression I am using

Re: Help with Pivot Table Results

vvira1316 — Fri, 29 Sep 2017 21:54:30 GMT

Hi Gary,

Based on the information in the image 1300 will not show up there as combination of Measure date and AR date for 1300 is not 1/31/2017 and 2/28/2017, they both are 2/28/2017.

BR,

Vijay

Re: Help with Pivot Table Results

dinuwanbr — Sat, 30 Sep 2017 08:55:03 GMT

Hi Gary,

Please check the data you have given in the sample.

Rgds,

Tharindu

Re: Help with Pivot Table Results

Mon, 02 Oct 2017 14:04:36 GMT

1300 is the AR remaining at 2/28/17 for loans that existed at 1/31/2017 (i.e. loans 123 and 456). The data I am showing is what my data model is right now--maybe I it needs to be transformed a bit? I am working with ~36 periods, so flagging loans as existing at a each measurement date would be labor intensive, so looking for a better solution that something like that.

Re: Help with Pivot Table Results

vvira1316 — Mon, 02 Oct 2017 15:37:39 GMT

Hi Gary,

Your description of issue and information were not aligned. Would it be possible for you to provide sample data/script/app/expression you are using with expected result. It will help to help you.

BR,

Vijay