topic Re: last date only moving averaged display in QlikView

last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 16:30:10 GMT

I am looking for a 3 days moving average - I can calculate it, using

rangeavg(above(sum(Score),0,3))

but I want to display only the result for the highest date.

so instead of

I would like to see only the yellow highlighted one, when I try to filter my calculation changed since it is ignoring the non filtered. .

I tried to apply so set analysis to it but did not help.

Any idea?

Re: last date only moving averaged display

sunny_talwar — Mon, 06 Nov 2017 17:13:35 GMT

Try this

rangeavg(above(sum({<MyDate>}Score),0,3)) * Avg(Aggr(If(Max(TOTAL <Name> MyDate) = MyDate, 1), Name, MyDate))

I have assumed that max mydate might differ for each name... if this isn't true, then you can have a simpler expression

Re: last date only moving averaged display

trdandamudi — Mon, 06 Nov 2017 17:16:38 GMT

Please see the attached file.. (I am using version 12). Hope this is what you are looking for:

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:19:06 GMT

Not matching original calculations?

moving average is

24/10/2017 Ben 75.33 and not like you have 100

24/10/2017 Julia 75.33 and not like you have 85

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:19:17 GMT

Not matching original calculations?

moving average is

24/10/2017 Ben 75.33 and not like you have 100

24/10/2017 Julia 75.33 and not like you have 85

Re: last date only moving averaged display

trdandamudi — Mon, 06 Nov 2017 17:21:25 GMT

Sunny do have the calculations that you need (75.33). Did you check ?

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:24:59 GMT

no Sunny go something else? no? or am I very confused?

Re: last date only moving averaged display

trdandamudi — Mon, 06 Nov 2017 17:27:45 GMT

This is what Sunny is getting:

Re: last date only moving averaged display

sunny_talwar — Mon, 06 Nov 2017 17:29:56 GMT

Are you not seeing this?

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:30:29 GMT

when I open Sunny's Q (2).qvw

I get:

maybe because I am using Q11 and Sunny is using Q12,any idea?

Re: last date only moving averaged display

sunny_talwar — Mon, 06 Nov 2017 17:31:31 GMT

Enabled the other two expressions also

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:32:27 GMT

no maybe because I am using Q11 and you are Q12 , I see:

Re: last date only moving averaged display

Anonymous — Mon, 06 Nov 2017 17:34:33 GMT

Sorry all, I see it now, not sure why I open another file first.

Re: last date only moving averaged display

sunny_talwar — Mon, 06 Nov 2017 17:34:35 GMT

Q11 or Q12 should not make any difference... are you still not seeing what I posted?