topic burn down chart formula help in QlikView https://community.qlik.com/t5/QlikView/burn-down-chart-formula-help/m-p/429092#M159949 <HTML><HEAD></HEAD><BODY><P>i have a total value for 6 months of 900, then i have monthly values month1:10, month2:20, Month3:20, ... etc.&nbsp; </P><P>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.</P><P></P><P>Please help </P></BODY></HTML> Thu, 18 Oct 2012 14:21:51 GMT nam 2012-10-18T14:21:51Z burn down chart formula help https://community.qlik.com/t5/QlikView/burn-down-chart-formula-help/m-p/429092#M159949 <HTML><HEAD></HEAD><BODY><P>i have a total value for 6 months of 900, then i have monthly values month1:10, month2:20, Month3:20, ... etc.&nbsp; </P><P>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.</P><P></P><P>Please help </P></BODY></HTML> Thu, 18 Oct 2012 14:21:51 GMT https://community.qlik.com/t5/QlikView/burn-down-chart-formula-help/m-p/429092#M159949 nam 2012-10-18T14:21:51Z Re: burn down chart formula help https://community.qlik.com/t5/QlikView/burn-down-chart-formula-help/m-p/429093#M159950 <HTML><HEAD></HEAD><BODY><P>rangesum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TotalMSBL</SPAN><SPAN style="font-size: 8pt;">)<EM><STRONG>0,rowno())) </STRONG></EM></SPAN></P><P><SPAN style="font-size: 8pt;"><EM><STRONG>Sorted</STRONG></EM></SPAN></P><P></P></BODY></HTML> Thu, 18 Oct 2012 14:29:26 GMT https://community.qlik.com/t5/QlikView/burn-down-chart-formula-help/m-p/429093#M159950 nam 2012-10-18T14:29:26Z