Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Antony3
Contributor III
Contributor III

Cumulative Line Chart containing Variables

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: 

2025-03-18_12h18_14.png

 

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?

2025-03-18_12h18_19.png

Labels (4)
3 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

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
Contributor III
Contributor III
Author

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
Partner - Creator III
Partner - Creator III

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