topic Re: Rolling 30-day Average in QlikView

Rolling 30-day Average

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I need to find rolling 30-day average based on the date but need to do achieve this in the script (not by using expressions).

Attached the sample data, which has file name, file size, file date and file type. File Name has two file types. I need to get the rolling 30 day file size average with respect to selections.

Alo I need to create a flag by comparing the normal average and Rolling 30-days average.

(If Normal avg >= Rolling 30-days avg then 0 otherwise 1) - Flag - (This is the reason that I need to achieve this in script itself).

Please help me out.

Thanks,

Siva.

Re: Rolling 30-day Average

lorenzoconforti — Thu, 12 Oct 2017 13:30:58 GMT

Hi Siva, do you need a 30 rolling average by File Type?

Re: Rolling 30-day Average

sunny_talwar — Thu, 12 Oct 2017 13:31:57 GMT

So basically you want that for each File Type, it should find the average of last 30 days on any particular date? File Names are different, that doesn't matter?

Re: Rolling 30-day Average

lorenzoconforti — Thu, 12 Oct 2017 14:29:37 GMT

If what you need is a rolling average by file type, please see attached

I'm sure this can be done much more efficiently but hopefully this helps

Re: Rolling 30-day Average

MK9885 — Thu, 12 Oct 2017 14:53:13 GMT

Maybe this one if I understood correctly?

Find the attachment.

Re: Rolling 30-day Average

Anonymous — Thu, 12 Oct 2017 15:22:48 GMT

Thanks Lorenzo. But I want this rolling average by file date.

Re: Rolling 30-day Average

lorenzoconforti — Thu, 12 Oct 2017 15:36:30 GMT

Didn't it get answer on this other post? Rolling 30-days Average

Do you mind amending the Excel and insert in there what exactly you are looking for? It will be easier to understand