topic Re: Average of Set Expression in QlikView

Average of Set Expression

Anonymous — Thu, 31 Mar 2016 17:12:46 GMT

Hello,

I am a beginner on Qlikview and i would like to do the Average of percentage of different AsOf (2 here) into a Pivot Table.

I tried the expression:

AVG({$< AsOf = {">=$(=Num(AddMonths(Max(STEAsOf),-2)))<=$(=Num(Date(STEAsOf, 'DD/MM/YYYY')))"}>} Sum(TOTAL <Job> STE)/SUM(TOTAL STE))

But it doesn't work 😕

Please find a sample attached here.

Thanks you in advance for your help,

Sébastien.

sunny_talwar — Thu, 31 Mar 2016 17:16:10 GMT

Is this the same question?

My bad, may be this:

Avg(Aggr(Sum(TOTAL <Job> STE)/SUM(TOTAL STE), Job))

swuehl — Thu, 31 Mar 2016 17:27:46 GMT

Maybe this?

[It's a little confusing that you keep changing your AsOf field name]

Sum({$< AsOF = {">=$(=Num(AddMonths(Max(AsOF),-2)))<=$(=Num(Date(AsOF, 'DD/MM/YYYY')))"}>} Total<Job> STE)

/SUM({$< AsOF = {">=$(=Num(AddMonths(Max(AsOF),-2)))<=$(=Num(Date(AsOF, 'DD/MM/YYYY')))"}>} TOTAL STE)

edit: And just in case you wonder why I dismissed the avg() function:

Anonymous — Fri, 01 Apr 2016 07:14:19 GMT

Thanks a lot it works perfectly !