Less than date in set analysis

Fri, 13 Mar 2015 10:11:37 GMT

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

Re: Less than date in set analysis

Gysbert_Wassenaar — Fri, 13 Mar 2015 10:23:42 GMT

Set analysis expressions calculate the set at the chart level, not the row level. See this document for more information: Calculating rolling n-period totals, averages or other aggregations

topic Less than date in set analysis in QlikView

Less than date in set analysis

Re: Less than date in set analysis