Burn down chart

karin_nevo — Tue, 14 May 2019 19:06:19 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

Re: Burn down chart

Nicole-Smith — Tue, 14 May 2019 21:22:03 GMT

So you just want to show the number on the chart but not linked to your dimensions/expressions?

You can add the expression as text here:

You can move it to where you want it by holding down CTRL+SHIFT (a red border should show around it), and then you can click and drag it to where you want it (while still holding down CTRL+SHIFT).

topic Burn down chart in QlikView

Burn down chart

Re: Burn down chart