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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Rolling sum inQlikview script

I have created column 1,2,3,4 divide I need to do the calculations in back end based on divide values.

For column 1 need to put value constant divide value for 12.
and if value  is 24 then need to make calculation for volumn 1 for 24 is
value for 1 for 24=(value for column 1 for 12+value for column 1 for 24)/2

value for 1 for 36=(value for column 1 for 12+value for column 1 for 36)/2

value for 1 for 48=(value for column 1 for 12+value for column 1 for 48)/2

for 2,3,4 need to show rolling values based on divide value 12.

for eg-

value for 2 for 12 = value for column 2 for 12
value for 2 for 24 = value for column 2 for 12+value for column 2 for 24
value for 2 for 36 = value for column 2 for 12+value for column 2 for 24+value for column 2 for 36

2 Replies
kishorj1982
Creator II
Creator II
Author

Hi All,

Can you please suggest on this.

thanks

dwarikapanigrah
Contributor III
Contributor III

Hi Kishor

As per comment changes are made, I have done for Value 1 , Please do the same for Value 2 ,..3 & 4.

Regards

Dwarika Panigrahi