Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Employee
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

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: burn down chart formula help

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

Sorted

View solution in original post

1 Reply
Highlighted
Employee
Employee

Re: burn down chart formula help

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

Sorted

View solution in original post