Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Qlikview: Rolling! Help me!

Hello!!!!

I have this table below and i would like to add the expression highlighted in red.

The "rolling" row, should take the value from "ALM On Hand" (that is just on a single period) and then add the Delta of each month to get the balance. How this can be done?

 

i created a sample where i'm not able to aggregate.. 

THank you!!

rOLLING.PNG

Labels (1)
2 Replies
Chanty4u
MVP
MVP

May be this

Above(Sum([ALM On Hand])) + Sum([Delta])

 

qlikviewaf
Creator
Creator
Author

not working