Average of Set Expression

[Anonymous]

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]

Is this the same question?

My bad, may be this:

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

[swuehl · Accepted solution]

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:

Average – Which average?

[Anonymous]

Thanks a lot it works perfectly !