topic looking for the appropriate function in QlikView

looking for the appropriate function

Anonymous — Mon, 09 Apr 2018 06:54:01 GMT

Hi guys,

I am stuck a little bit.

I have to create the following function (Sum(package size*sold))/Number

So, I have loads of differenct product with different package sizes Eg:

Product	Package size	Sold
Chocolate bar	5	12
Chocolate bar	10	28
Chocolate bar	20	27
Chocolate bar	30	11
Chocolate bar	40	14

Is there a function which calculates the package size*sold for each product?

Cheers, Joe

Re: looking for the appropriate function

sunny_talwar — Mon, 09 Apr 2018 17:34:03 GMT

This should work the way you have it

Sum([package size]*sold)

Re: looking for the appropriate function

vishsaggi — Mon, 09 Apr 2018 17:44:26 GMT

use your formula in a pivot table with Product as dim and expr as your sum(). Are you looking for %ge by product. What is Number in your expr? You mean total sum of your Packagesize*sold? If yes may be you can use like

= Sum(PackageSize * Sold)/Sum(TOTAL PackageSize * Sold)