topic Re: Loop, how? Need only in script: average for all dates less current in QlikView

Loop, how? Need only in script: average for all dates less current

warfollowmy_ver — Wed, 12 Oct 2016 00:58:15 GMT

Need help!

Need only in script: average for all dates less current. Example in excel.

Please help! It is necessary only in the script!

sunny_talwar — Wed, 12 Oct 2016 01:29:13 GMT

May be this:

Table:

LOAD * INLINE [

Date, sub1, sub2, SUM

1/1/2016, 1, 1, 1

1/2/2016, 1, 1, 2

1/3/2016, 1, 2, 3

1/4/2016, 2, 2, 4

1/5/2016, 2, 3, 5

1/6/2016, 2, 3, 6

1/7/2016, 3, 4, 7

1/8/2016, 3, 4, 8

1/9/2016, 3, 5, 9

1/10/2016, 3, 5, 10

];

FinalTable:

LOAD Date,

sub1,

sub2,

SUM,

Temp1,

Temp2,

Temp1/Temp2 as [Avg Group by Date];

LOAD *,

RangeSum(Peek('Temp1'), SUM) as Temp1,

RangeSum(Peek('Temp2'), 1) as Temp2

Resident Table

Order By Date;

DROP Table Table;

warfollowmy_ver — Wed, 12 Oct 2016 01:31:58 GMT

Thank you so much!