Discussion Board for collaboration related to QlikView App Development.
I have the following table and likes to have a line graph of the Value for the period START to START+ YEARS.
The SUM should be only taken once per No.
Any suggestion for an expression? the dimension is Years.
May be like this:
Year + IterNo() - 1 as Year
While IterNo() <= NoOfYears;
Year(Start) as Year,
Years as NoOfYears
(html, codepage is 1252, embedded labels, table is @1);
Line chart Dimension
=Sum(Aggr(Value, No., Year))
View solution in original post
Perfect! Many thanks Sunny.