Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner
Partner

Single row computation

Hi QV brains i need a help pls: I've to calculate   

sum(A * B) / sum(B)

where B is the price of  5 different products.

How can i do it

Tks

2 Replies
jaumecf23
Creator III
Creator III

Maybe this :

sum({<ProductID={'Product1','Product2','Product3','Product4','Product5'}>}Amount)

sunny_talwar

So, what is the problem... is this not working? sum(A * B) / sum(B)