Calculated start value in aggregated line chat

Thu, 10 Sep 2009 01:00:46 GMT

Hi all, I have a line chart showing a simple count with full accumulation and a timeline as x-axes. It works fine for the selected period apart from the lines start value. I want the staring point to represent a full accumulation of all previous values such as the line shows the accumulated values for the choosen period.
I've tried to use set analysis as well but have not manged to resolve it. Any help appreciated!
/Martin

Calculated start value in aggregated line chat

Tue, 03 Nov 2009 03:49:39 GMT

Hi Martin,

Maybe you have solved your problem by now? If not . . . . I had the same requirement, I solved it the following way:

>>>>>

Load id,

if(previous(Id) <> Id, rangesum(0.000001, RemainingLaborUnits), rangesum( RemainingLaborUnits, peek( 'CumRemainingLaborUnits' ) ) ) as CumRemainingLaborUnits ,

.....

SQL

Select * , 0 as CumRemainingLaborUnits

from PROJECTSPREAD

order

by id, startdate;

>>>>>

This creates a sort of running-totals or cumulatives per Id-group. The 0,000001 is just to make sure that I get a line in my chart for every period.

Hope this helps 🙂

Jan

topic Calculated start value in aggregated line chat in QlikView

Calculated start value in aggregated line chat

Calculated start value in aggregated line chat