Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
TwinPinesMall
Partner - Contributor II
Partner - Contributor II

Linechart with two dimensions accumulated doesnt stack

Hi everybody

I try to display a linechart that shows the accumulated sum of hours spent in different projects over time:

My Code for the Fact:

Aggr(RangeSum(Above(Sum(TimeSpent), 1, RowNo())), Project, Datebooking)

Result:

17-06-_2019_17-14-21.png

I would expect a growing linechart over the time...

 

1 Solution

Accepted Solutions
TwinPinesMall
Partner - Contributor II
Partner - Contributor II
Author

I got a solution - but not the best right now:

My Code for the Fact:

Aggr(RangeSum(Above(Sum(TimeSpent), 1, RowNo())), Project, (Datebooking,(NUMERIC,ASCENDING)))

Result:

18-06-_2019_12-03-29.png

I found it out by creating a table with all the intermediat results of the formula.

378afeda35bd42c9893023de8c0ac2af.png

I realised that the RowNo() function counted the Months and not the Projects. With the sorting part of the Aggr() function, the Codes worked.

 

View solution in original post

1 Reply
TwinPinesMall
Partner - Contributor II
Partner - Contributor II
Author

I got a solution - but not the best right now:

My Code for the Fact:

Aggr(RangeSum(Above(Sum(TimeSpent), 1, RowNo())), Project, (Datebooking,(NUMERIC,ASCENDING)))

Result:

18-06-_2019_12-03-29.png

I found it out by creating a table with all the intermediat results of the formula.

378afeda35bd42c9893023de8c0ac2af.png

I realised that the RowNo() function counted the Months and not the Projects. With the sorting part of the Aggr() function, the Codes worked.