Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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))
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))
Perfect! Many thanks Sunny.
Best regards
Jens