plot sum from beginning date through date on x axis

Mon, 07 Feb 2011 22:38:55 GMT

I need to plot the daily A/R Balance on a line chart. The measure is named 'ARBal' and can be calculated by any data by summing all entries up through the ARAgeDate field, which is the dimension I'd like to use on the X axis. For example, if 12/31/2010 were a plot on my X axis, I would sum ARBal where ARAgeDate <= '12/31/2010'. Please advise.

thanks!

plot sum from beginning date through date on x axis

johnw — Tue, 08 Feb 2011 01:30:20 GMT

The simple way:

Dimension = ARAgeDate
Expresison = sum(ARBal)
turn on full accumulation

But that's probably not what I'd do, because if your data starts in year 1974, for instance, and you select January 2011 to look at, it will only accumulate from the start of January 2011, not from 1974.

I would likely generate an AsOf table that ties each AsOfDate to that ARAgeDage and every previous ARAgeDate. Use AsOfDate in the chart, again use sum(ARBal), but don't use full accumulation. The accumulation would happen as a result of the data model. Therefore, even if you select January 2011, it will still accumulate from the start of the data.

topic plot sum from beginning date through date on x axis in QlikView

plot sum from beginning date through date on x axis

plot sum from beginning date through date on x axis