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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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 ....