Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Weighted Average in Script not as Expression

Has anyone been successful in calculating the weighted average at script level and not run time.

2 Replies
Highlighted
Master II
Master II

Weighted Average in Script not as Expression

Can you be a bit more specific?
One idea would be to build the averages and in a second table you build the weighting criteria and then merge both tables.

Peter

Highlighted
MVP
MVP

Weighted Average in Script not as Expression

Example:

LOAD
SomeField
,sum(Price * Weight) / sum(Weight)
RESIDENT SomeTable
GROUP BY SomeField
;