Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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