Rolling sum inQlikview script

kishorj1982 — Fri, 03 Nov 2017 12:42:43 GMT

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

Re: Rolling sum inQlikview script

kishorj1982 — Mon, 06 Nov 2017 03:41:43 GMT

Hi All,

Can you please suggest on this.

thanks

Re: Rolling sum inQlikview script

dwarikapanigrah — Mon, 06 Nov 2017 06:23:51 GMT

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

topic Rolling sum inQlikview script in QlikView

Rolling sum inQlikview script

Re: Rolling sum inQlikview script

Re: Rolling sum inQlikview script