Adding product quantities or product $ sales within a qlikview script

[Anonymous]

Hi good qlikview community people,

I need to report on the sum of the quanitites and / or $ sales for all our products.

so I have a "Product" table with different product codes

Then I have a "SalesOrderLine" table with all product codes sold in different sales order numbers, including when the sales order was created, the QTYOrdered, the SellPrice... etc...

What would be the best/simplest function to use to:

A - Count QTY's on Sales Orders per product

B - Sum all the sell prices

Any help would be appreciated...

Thanks

Fabrizio Giorgio

[Anil_Babu_Samineni]

Perhaps these

1) Count({<Product = P([Sales Order])>}QTYOrdered)

2) Sum(TOTAL [Sell Price])

[Anonymous]

Thanks Anil,

I will give it a try and let you know!!

how do I specify "per product code" for the SUM(Total [Sell Price]) ?

thanks again...

[Anil_Babu_Samineni]

Looks like this

Sum(TOTAL <Product Code> [Sell Price])

OR

Sum({$<[Product Code]=>}TOTAL [Sell Price])