Graph w/o double values

[#1]

Dear all,

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.

Many thanks

Jens

No.	Value	Start	Years
5	19530	11.11.2013	4
47	3000	06.12.2014	7
48	16276	05.08.2013	4
48	16276	05.08.2013	4
48	16276	05.08.2013	4
49	180758	21.11.2014	6
50	25880	01.07.2015	7
50	25880	01.07.2015	7
50	25880	01.07.2015	7
51	8183	16.07.2015	10
51	8183	16.07.2015	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
56	3221	05.03.2018	10
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7
57	26370	02.08.2016	7

[sunny_talwar · Accepted solution]

May be like this:

Table:

LOAD No.,

    Value,

    Start,

  Year + IterNo() - 1 as Year

While IterNo() <= NoOfYears;

LOAD No.,

    Value,

    Start,

    Year(Start) as Year,

    Years as NoOfYears

FROM

[https://community.qlik.com/thread/234461]

(html, codepage is 1252, embedded labels, table is @1);

Line chart Dimension

Year

Expression

=Sum(Aggr(Value, No., Year))

[#3]

Perfect! Many thanks Sunny.

Best regards

Jens