topic Re: Expression help in QlikView

Expression help

Mon, 21 Jul 2014 08:46:33 GMT

Hi all,

I got the following expression:

sum(aggr(rangesum(above(total sum({< Year = {$(=(max(Year)))}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>} RevenueAmount/(1+Sales.Red)),0,4)),Week))

Now this should give me a 4 week average but it isn't. I tried moving my (()) but can't figure it out. Somebody got a clue what I'm doing wrong?

like week 4 gives a average over the past 4 weeks.

kind regards

Re: Expression help

MK_QSL — Mon, 21 Jul 2014 09:06:04 GMT

Try

SUM(Aggr(RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>}RevenueAmount),0,4),Week)))

RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>}RevenueAmount),0,4)

Re: Expression help

Mon, 21 Jul 2014 10:09:06 GMT

hmm Both aren't me showing any data.

SUM(Aggr(RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'2WIN'}, TodoSubtype = {'AB'}>}RevenueAmount)),0,4),Week))

It only gives me the number 4. Instead of a 4 weeks total.

Re: Expression help

tresB — Mon, 21 Jul 2014 10:14:58 GMT

Could you post your sample qvw?