Hi,
I've created the following table
| Period | Period End Date |
| Mar 2014 | 30/03/2014 |
| Apr 2014 | 30/04/2014 |
| May 2014 | 31/05/2014 |
| Jun 2014 | 30/06/2014 |
| Jul 2014 | 31/07/2014 |
| Aug 2014 | 31/08/2014 |
| Sep 2014 | 30/09/2014 |
| Oct 2014 | 31/10/2014 |
| Nov 2014 | 30/11/2014 |
| Dec 2014 | 31/12/2014 |
| Jan 2015 | 31/01/2015 |
| Feb 2015 | 28/02/2015 |
| Mar 2015 | 31/03/2015 |
Which is aimed at providing a view over the previous 12 months, the table was created through script and links to another table by the 'Period' column.
I have a ledger table that includes entries, I want to include a new column called 'Inventory Value', this needs to be the sum of all entries before and including the 'Period End Date', so therefore is I had an entry for 05/011/2014 it would appear in Nov 2014, Dec 2014, Jan 2015 etc.
I've tried the following formula Sum({$<[ILE.Posting_Date] = {"<=$([Period End Date])"}>} ILE.Cost_Amount_Actual) however the result is no different to Sum(ILE.Cost_Amount_Actual) since it is only summing the entries for that period.
What I have I missed? I haven't wrote a QlikView app for a few years so out of practice.
Cheers
Steve
