Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not show total accumulation data point.

Don't suppose anyone would know how to not have the total accumulation show at the end of a line in a graph that has full accumulation on and just have the last data points value?  I made a target line that is the accumulation of double the actual sales accumulation line.  It is linear and is the accumulation of the total accumulation of the sales divided by the number of days times 2.  The last day has the correct value but there is another step of accumulation added to the total though there are no more days.   Here are the accumulation vales for the last five days with the last number being the total.

8-May$83,691,413.35 $41,738,021.34
9-May$84,545,407.37 $42,157,041.42
10-May$85,399,401.38 $42,699,700.69
11-May$86,253,395.40 $42,699,700.69
$87,107,389.41 $42,699,700.69

Everything is good except for the total.  Any ideas on a fix or is this a bug?

9 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Can you post your app?

Not applicable
Author

I got it solved another way.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Please post your solution!

Not applicable
Author

=RangeSum(Above(Sum(Sales),0,RowNo())) and offset the number of days divided on with a + 1.  This will get you what you want.

Not applicable
Author

You answered it in a slightly differntly worded post from me Jason!

Not applicable
Author

This question was originally a work around that was solved by an even simpler work-arround stated above.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Ah 🙂

Not applicable
Author

A Starbucks accross from a Starbucks moment?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Something like that 😉