Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DMP_MXNS
Contributor
Contributor

how to calculate running sum in an app

I have business analysts that need to do calculations in an app, such as calculating running sums.  I can't do this in the data load script because I don't know ahead of time what variations the business analysts will need, as they may group these calc by different dimensions.  I try testing this by creating a new app, new sheet, put in my 2 dims and 1 measure.  Let's say it's Year, Country, and sum(sales).  I now want to calculate the running total of sales by country, breaking by year.  I don't see how to do this in QS Nov 2017.  Is the only way to do it in a script?  If so then how do we give the flexibility to BA's to do any type of calculation on data on the fly that they may think of while slicing and dicing?

0 Replies