topic Re: Burn down chart in QlikView

Burn down chart

karin_nevo — Tue, 14 May 2019 19:02:23 GMT

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

sunny_talwar — Tue, 14 May 2019 19:52:46 GMT

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)) )

karin_nevo — Wed, 15 May 2019 06:55:09 GMT

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!

sunny_talwar — Wed, 15 May 2019 11:07:33 GMT

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

karin_nevo — Wed, 15 May 2019 12:07:43 GMT

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

sunny_talwar — Wed, 15 May 2019 12:15:43 GMT

Try this

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

karin_nevo — Thu, 16 May 2019 06:34:58 GMT

It works!

thank you very much for your help 🙂