topic Moving Average Problem in QlikView

Moving Average Problem

Wed, 25 Nov 2020 16:16:04 GMT

I am facing some problem.

Below is my table:

Date Price

6/30/2016	207.210007
6/29/2016	204.839996
6/28/2016	201.479996
6/27/2016	201.589996
6/24/2016	203.630005
6/23/2016	209.809998
6/22/2016	208.649994
6/21/2016	208.300003

Problem 1 I cannot calculate moving average 10 days in script, I only can moving average 2 days

rangeavg(Price,previous(Price)

Problme 2 Since I dont create the moving average field in the table but I want to add (Price > Moving average 10days Price) as calculated dimension

that is

=if(rangeavg(above(sum(Price),0,10))>0,1,0)

Can anybody give me some advices?

Thanks!

Re: Moving Average Problem

marcus_sommer — Fri, 01 Jul 2016 08:08:35 GMT

Try this: rangeavg(above(sum(Price),rowno(),10))

- Marcus

Re: Moving Average Problem

sunny_talwar — Fri, 01 Jul 2016 08:13:31 GMT

Is it possible to share a sample with the desired output if what marcus_sommer‌ has provided doesn't work for you?

Best,

Sunny

Re: Moving Average Problem

Fri, 01 Jul 2016 08:28:42 GMT

It is work in the expression but it doesnt work in calculated dimension

Re: Moving Average Problem

Anonymous — Fri, 01 Jul 2016 15:00:40 GMT

Hi Garnett,

Please find attached the qvw.

Hope this helps to solve your 1st query.

Re: Moving Average Problem

marcus_sommer — Fri, 01 Jul 2016 17:48:47 GMT

If you want to use aggregations within the dimension you will need to wrap the calculation within an aggr-function:Calculated Dimensions‌

- Marcus

Re: Moving Average Problem

Sat, 02 Jul 2016 00:09:09 GMT

Thanks!

Re: Moving Average Problem

Sat, 02 Jul 2016 00:09:17 GMT

Thanks!

Re: Moving Average Problem

oknotsen — Sat, 02 Jul 2016 09:05:37 GMT

If your question is now answered, please flag the Correct Answer and possible Helpful answers.

If not, please make clear what more information on this topic you are looking for .

Re: Moving Average Problem

vinieme12 — Sat, 02 Jul 2016 10:01:52 GMT

Hi@Garnett,

Having complex expression only will degrade your dashboard performance

Add the DateGroup to your load script as below

DATA:

LOAD

Date,

Price,

date(subfield(class(Date,10),' ',1),'DD-MM-YY')

&' TO '&

date(subfield(class(Date,10),' ',5),'DD-MM-YY') as DateGroup

FROM TABLENAME;

LEFT JOIN(DATA)

LOAD DateGroup,

Avg(Price)

RESIDENT DATA

Group BY DateGroup;

This should simplify your calculations

Re: Moving Average Problem

Sun, 03 Jul 2016 08:13:07 GMT

Thanks!

Re: Moving Average Problem

oknotsen — Sun, 03 Jul 2016 14:50:19 GMT

If your question is now answered, please flag the Correct Answer and possible Helpful answers.

If not, please make clear what more information on this topic you are looking for .