Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Burn down chart

Hi,

I am creating a burn down chart using the following expression:

sum(total Hours)-RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))).

and Quarter as dimension

I am getting the required result, but I want the chart to display also the sum of hours (sum Total Hours) for all periods.

For example, in TableCapture.PNG, the total appears in the expression column (1382).

I want the same total to appear as starting point in ChartCapture.PNG . Is it possible?

I tried to use "Show Total" in dimension limit but it didn't work

 

Thanks,

Karin

 

6 Replies
Highlighted

Re: Burn down chart

Are you looking for an additional point on the x axis which displays the total and then the burn down? May be try this

Dim:
LOAD * INLINE [
Dim
1
2
];

 

and then use this as your dimension

Pick(Dim, 'Total', Quarter)

and this expression

Pick(Dim,
  Sum(Hours),
  Sum(TOTAL Hours) - RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))
)
Highlighted
Contributor III
Contributor III

Re: Burn down chart

Thank you for your help.

I tried what you suggested, but I get: "No data to display" message on the chart.

any idea why?

 

thanks!

Highlighted

Re: Burn down chart

Would you be able to share a sample to test this out?

Highlighted
Contributor III
Contributor III

Re: Burn down chart

 

I was able to get a result now on a sample data, but it is not the correct result.

On the first chart, you can see the correct data for all quarters (without total)

On the second chart, the total is correct, but the data for the quarters is incorrect.

 

thanks,

Karin

Highlighted

Re: Burn down chart

Try this

Pick(Dim,
Sum(Hours),
Sum(TOTAL Hours) - RangeSum(Above(Sum(If(Dim = 2, Hours)), 0, RowNo()))
)
Highlighted
Contributor III
Contributor III

Re: Burn down chart

It works!

thank you very much for your help 🙂