Cumulative Line Chart containing Variables

[Antony3]

Hi All,

I have a table of data that is driven primarily by variables.

- Days billed 1 example $(vBillable_Day1Visit_AllTime)

- Days billed 2 example $(vBillable_Day2Visit_AllTime)

The problem is that only Calendar Year-Month contains a non variable.

This produces a table that looks like this: 

Is it possible, in the front end table/variables, to update the expression so that it becomes cumulative like the below? Not had much luck with googling solutions so maybe I'm missing something obvious?

 

[morgankejerhag]

How do you mean that the data is driven by variables? Is it a table in the data model? A variable can only contain a single value and not one value per dimensional value etc.

[Antony3]

Sorry, probably bad wording.

All of the columns in the tables are variables. When I try to do a cumulative expression it doesn't work. I tried using the below and messed around with the sum/total savings column but it changed every cell to a Null value.

I tried replacing Sum(total savings) with the variable.

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

https://community.qlik.com/t5/App-Development/Cumulative-Line-Graph-QlikSense/td-p/29717

[morgankejerhag]

Can you upload a sample app with dummy data where you are trying to use the variables?