topic Re: Cumulative Total in QlikView

Cumulative Total

Wed, 25 Nov 2020 16:16:04 GMT

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@

Re: Cumulative Total

Frank_Hartmann — Fri, 17 Jun 2016 15:08:22 GMT

Like that?

Re: Cumulative Total

swuehl — Fri, 17 Jun 2016 15:11:18 GMT

you can have a look into

Re: Display data point values on line chart

Re: Cumulative Total

Mon, 20 Jun 2016 08:21:52 GMT

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

Re: Cumulative Total

Frank_Hartmann — Mon, 20 Jun 2016 09:49:52 GMT

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

Re: Cumulative Total

Mon, 20 Jun 2016 12:39:02 GMT

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?

Re: Cumulative Total

Frank_Hartmann — Mon, 20 Jun 2016 12:53:48 GMT

can u upload a sample?