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: 
nam
Former Employee
Former Employee

burn down chart formula help

i have a total value for 6 months of 900, then i have monthly values month1:10, month2:20, Month3:20, ... etc. 

what i want to show on a graph is a decreasing value so month1: 900-10, month2:900-10-20, Month3:900-10-20-20 and so on. so the graph starts with the total at the first month and with each month the graph decreases. the formula im using is =TotalMS-rangesum(Above(sum(MileSBL))). the dimension on the graph is YearMonth.

Please help

Labels (1)
1 Solution

Accepted Solutions
nam
Former Employee
Former Employee
Author

rangesum(Above(sum(TotalMSBL)0,rowno()))

Sorted

View solution in original post

1 Reply
nam
Former Employee
Former Employee
Author

rangesum(Above(sum(TotalMSBL)0,rowno()))

Sorted