topic Cumulative Line Chart containing Variables in App Development

Cumulative Line Chart containing Variables

Antony3 — Tue, 18 Mar 2025 12:18:56 GMT

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?

Re: Cumulative Line Chart containing Variables

morgankejerhag — Tue, 18 Mar 2025 13:13:04 GMT

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.

Re: Cumulative Line Chart containing Variables

Antony3 — Tue, 18 Mar 2025 14:57:09 GMT

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

Re: Cumulative Line Chart containing Variables

morgankejerhag — Sun, 23 Mar 2025 20:20:01 GMT

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