Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

14 Replies
philgood34
Creator II
Creator II
Author

Yes of course

but i don't know how send the file ... sorry

sunny_talwar

Check here

Uploading a Sample

philgood34
Creator II
Creator II
Author

thank's

here is the file

sunny_talwar

Check this out

Capture.PNG

Expression

If(Dimensionality() = 0, Sum(Aggr(Sum(CIB_MBTVTE)*Sum(VMS_CAHT), NCL_LIB))/Sum(VMS_CAHT), Sum(CIB_MBTVTE))

philgood34
Creator II
Creator II
Author

GREAT JOB !

i 'll study these expression to be able to reproduce ...

thank's a lot

see you !