Moving Month average

shruthibk — Wed, 18 Nov 2015 19:38:25 GMT

hi i got requirement to find moving month average of most recent month.but it should be done from scripting side.

my requirement is like

expected data model output should be like this for sum

LOAD metrics,

mobnthyear,

counter

FROM

[..\dataload\table1.qvd]

(qvd);

NoConcatenate

temp1:

load

metrics,

mobnthyear,

sum(counter) as COUNT

resident TEM

group by metrics, mobnthyear;

//order by mobnthyear desc;

left join(temp1)

load

metrics,

addmonths(mobnthyear,-1) as mobnthyear ,

sum(counter) as COUNT1

resident TEM

//where COUNT1 is notnull,

group by metrics, mobnthyear

;

// order by mobnthyear desc;

left join(temp1)

load

metrics,

addmonths(mobnthyear,-2) as mobnthyear ,

sum(counter) as COUNT2

resident TEM

group by metrics,mobnthyear;

// order by mobnthyear desc;

drop table TEM;

i wriiten code like this but i am not finding exam output plz help me to solve this

reggards ,

shruthi

topic Moving Month average in QlikView