topic Re: Graph w/o double values in QlikView

Graph w/o double values

Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Wed, 28 Sep 2016 18:52:00 GMT

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))

Thu, 29 Sep 2016 07:13:07 GMT

Perfect! Many thanks Sunny.

Best regards

Jens