Cumulative Total

[#1]

Hi

I am pretty new to QlikView so I need your help.

I have a bar chart that looks at the amount of sales orders for the current month. I also have a line on the chart that gives me the cumulative total for the current month. So the line goes up each days as the number of sales for the month increase (obviously it will never decrease). I would like to add one label to the final day to give the total number of sales orders so far.

The value on data points display the value for each day but I only want the last.

Your help would be appreciated

Thanks in advance

Dave@

[Frank_Hartmann]

Like that?

[swuehl]

you can have a look into

Re: Display data point values on line chart

[#4]

that looks good. But I can't see the code in the expression!

[Frank_Hartmann]

if you have Expression in chart like:

sum(Field)

than the expression for "Show Value" should be

sum(Field='Axis') with Axis='06' in my case

For showing different datapoint just replace the '06' with '05'  for showing the datapoint for '05'

hope that helps

[#6]

Hi Frank

That doesn't seem to work. is it because I have a bar chart showing the day values and the line showing the cumulative total. Any ideas?

[Frank_Hartmann]

can u upload a sample?