Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
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

 

1 Reply
Highlighted

Re: Burn down chart

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:
Untitled.png

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