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
Contributor III
Contributor III

Burn down chart Expression

Hi Team,

I have created a line graph with  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?

I have tried with total(plandate)-sum(if(plandate=xdate,1,0)).It is not coming. should we use accumulation for this ?

Thanks in Advance.

1 Reply
Highlighted
Not applicable

Re: Burn down chart Expression

Hi Prakash,

you should use the following formula:

Sum(Total testcases) - RangeSum(Above(Sum(testcases),0,RowNo()))

Greetings,

Marc