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.
