Help with Pivot Table Results

[#1]

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

[m_woolf]

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

=sum(Amount)

[#3]

=sum(Amount) is expression I am using

[vvira1316]

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

[dinuwanbr]

Hi Gary,

Please check the data you have given in the sample.

Rgds,

Tharindu

[#6]

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.

[vvira1316]

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