topic Re: Cumulative Line Graph - QlikSense in App Development

Cumulative Line Graph - QlikSense

andrew_sell — Fri, 27 Apr 2018 20:25:53 GMT

Good Afternoon,

I am looking for an expression to create a cumulative line graph based on the following data example.

Month Total Savings

Jan-2017 100000

Feb-2017 25000

March-2017 12500

April-2017 10000

In this example, I would want the line point to be 100000 for Jan, 125000 for Feb, 137500 for March and 147500 for April.

Thinking this might be simple, but i am having trouble accomplishing it.

Re: Cumulative Line Graph - QlikSense

tomasz_tru — Sat, 28 Apr 2018 06:39:04 GMT

rangesum( above( sum([Expression1]),0,rowno()))

Re: Cumulative Line Graph - QlikSense

L_Hop — Mon, 30 Apr 2018 07:50:24 GMT

Hi Andrew,

add your Month values as dimension and for the measure use:

aggr(rangesum( above( sum([Total Savings]),0,rowno())),Month)

after appropriate sorting your line chart will look like below. I think below is what you want.

regards,

O.Y

Re: Cumulative Line Graph - QlikSense

omodoshouses — Fri, 07 Dec 2018 19:06:42 GMT

Nights Revenue

50 -> 3000

100 -> 6000

......

leading to 500 Nights and 30000. I have managed to aggregate the revenue using the expressions you have already posted, however, I am having an issue with the aggregation of the duration. Also note that I have a variable of duration, which calculates the duration of every single reservation added in the spreadsheet.

Thanks a lot

Re: Cumulative Line Graph - QlikSense

omodoshouses — Fri, 07 Dec 2018 19:19:29 GMT

Hi and sorry for posting in this conversation but I believe you can help me out. I had the same issue and the solution you have provided helped me out. However, I still have an issue with the x-axis. My case is that the y-axis is the revenue while the x-axis is the number of nights (I am running a hotel). So lets say, I have a total revenue of 30000 and a total nights of 500 (so average revenue per night is 60), then I want to create a linear graph were the values would be shown as follows:

Nights Revenue

50 -> 3000

100 -> 6000

......

leading to 500 Nights and 30000. I have managed to aggregate the revenue using the expressions you have already posted, however, I am having an issue with the aggregation of the duration. Also note that I have a variable of duration, which calculates the duration of every single reservation added in the spreadsheet.

Thanks a lot

Re: Cumulative Line Graph - QlikSense

rkopinsk — Mon, 11 Oct 2021 20:37:23 GMT

How would the expression look like, if you were to start counting from the beginning by each beginning of the month, i.e. display only the recent month + add up daily sales until month ends and start over again?

Thank you!