Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.