topic Re: 20 days simple moving average in QlikView

20 days simple moving average

Anonymous — Fri, 03 Mar 2017 19:39:20 GMT

please provide a explanation on how can we create 20 days SMA in a load script. Have tried to search a lot but in vain.

Also have come across above function which can only be used in chart expressions, right? . please somebody shed a light on this.

isaiasdd — Fri, 03 Mar 2017 19:49:31 GMT

You want generate 20 days? Please post an example of what the output should look like.

Anonymous — Fri, 03 Mar 2017 20:07:23 GMT

for the sake of simplicity, consider for the below example i need a 2 days SMA

input table is a table with a daily transaction table

now the output table should look like this

Name	Date(DD/MM/YYYY)	Amount	SMA Amount
peter	20/01/2017	200	200
peter	21/01/2017	100	150
peter	22/01/2017	300	200
peter	23/01/2017	400	350
tom	20/01/2017	450	450
tom	21/01/2017	220	335
tom	22/01/2017	100	160
tom	23/01/2017	50	75