Discussion Board for collaboration related to QlikView App Development.
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
Are you looking for an additional point on the x axis which displays the total and then the burn down? May be try this
LOAD * INLINE [
and then use this as your dimension
Pick(Dim, 'Total', Quarter)
and this expression
Sum(TOTAL Hours) - RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))
Thank you for your help.
I tried what you suggested, but I get: "No data to display" message on the chart.
any idea why?
Would you be able to share a sample to test this out?
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.
Sum(TOTAL Hours) - RangeSum(Above(Sum(If(Dim = 2, Hours)), 0, RowNo()))
thank you very much for your help 🙂