Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graph w/o double values

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.ValueStartYears
51953011.11.20134
47300006.12.20147
481627605.08.20134
481627605.08.20134
481627605.08.20134
4918075821.11.20146
502588001.07.20157
502588001.07.20157
502588001.07.20157
51818316.07.201510
51818316.07.201510
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
56322105.03.201810
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
572637002.08.20167
1 Solution

Accepted Solutions
sunny_talwar

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


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

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


Capture.PNG

View solution in original post

Not applicable
Author

Perfect! Many thanks Sunny.

Best regards

Jens