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