topic Re: Burn down chart Expression in QlikView https://community.qlik.com/t5/QlikView/Burn-down-chart-Expression/m-p/906636#M314995 <HTML><HEAD></HEAD><BODY><P>Hi Prakash,</P><P></P><P>you should use the following formula:</P><P></P><P>Sum(Total testcases) - RangeSum(Above(Sum(<SPAN style="font-size: 13.3333px;">testcases</SPAN>),0,RowNo()))</P><P></P><P>Greetings,</P><P>Marc</P></BODY></HTML> Fri, 25 Sep 2015 08:28:14 GMT 2015-09-25T08:28:14Z Burn down chart Expression https://community.qlik.com/t5/QlikView/Burn-down-chart-Expression/m-p/906635#M314994 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have created a line graph with&nbsp; date in x axis (xdate) and count of test cases executed and planned in that particular date. I want to convert it into burn down chart.The expression i used is sum(if(plandate=xdate,1,0) and sum(if(exedate=xdate,1,0)).How to convert it into burndown chart?</P><P></P><P>I have tried with total(plandate)-sum(if(plandate=xdate,1,0)).It is not coming. should we use accumulation for this ?</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Thu, 04 Jun 2015 07:51:27 GMT https://community.qlik.com/t5/QlikView/Burn-down-chart-Expression/m-p/906635#M314994 Anonymous 2015-06-04T07:51:27Z Re: Burn down chart Expression https://community.qlik.com/t5/QlikView/Burn-down-chart-Expression/m-p/906636#M314995 <HTML><HEAD></HEAD><BODY><P>Hi Prakash,</P><P></P><P>you should use the following formula:</P><P></P><P>Sum(Total testcases) - RangeSum(Above(Sum(<SPAN style="font-size: 13.3333px;">testcases</SPAN>),0,RowNo()))</P><P></P><P>Greetings,</P><P>Marc</P></BODY></HTML> Fri, 25 Sep 2015 08:28:14 GMT https://community.qlik.com/t5/QlikView/Burn-down-chart-Expression/m-p/906636#M314995 2015-09-25T08:28:14Z