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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MadKow19
Contributor II
Contributor II

Function to aggregate columns

Hi,
I need help in defining an aggregate function. Database, contains fields:

load

DATE,
BANK NAME,
AMOUNT
[...]
from [...]

I create a table in which the columns are "Date", the rows are "BANK NAME".

I want to have a second column to sum up the amount of the previous three months.

aggr.JPG

The RangeSum(Above(..)) function sums my rows, how do I refer to the columns?

 

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Have a look at using the Before() and/or After() functions within your rangesum instead of Above() / Below()

 

View solution in original post

2 Replies
Or
MVP
MVP

Have a look at using the Before() and/or After() functions within your rangesum instead of Above() / Below()

 

MadKow19
Contributor II
Contributor II
Author

You're wonderful 🙂 Thank you, it works 🙂
I am a beginner and there is a lot ahead of me ....