Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philgood34
Creator II
Creator II

Average weight of a table

Hello,

I created this table

TABLE.png

totaux.png

Unfortunely, the average (22.85%) is not the weighted average as i looking for...

Do you know how do these weighted average ?

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Then try this

Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))

View solution in original post

14 Replies
sunny_talwar

What is the number you are expecting to see?

philgood34
Creator II
Creator II
Author

I'am expecting (23.10%*3822831+15.4%*2875939+28.8%*680411+24.10%*1107559)/8486740 = 21.08%

sunny_talwar

Then try this

Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))

philgood34
Creator II
Creator II
Author

I understand your answer (thank's); but as a begginer i don't know where insert these instruction ? Indeed, the total line is automaticly created after the selection as shown :

totaux2.png

i can't write an fx ...

sunny_talwar

What other options do you see here? Do you see Expression Default?

Capture.PNG

philgood34
Creator II
Creator II
Author

no

i see

auto

avg

count

max

min

sum

none

but not

expression fx

😞

sunny_talwar

Can you check with auto and this expression

Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))

philgood34
Creator II
Creator II
Author

if i select auto i have no window to write the expression ???

totaux3.png

sunny_talwar

Would you be able to share a sample qvf file?