Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps these
1) Count({<Product = P([Sales Order])>}QTYOrdered)
2) Sum(TOTAL [Sell Price])
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...
Looks like this
Sum(TOTAL <Product Code> [Sell Price])
OR
Sum({$<[Product Code]=>}TOTAL [Sell Price])