Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

fgiorgio
Contributor

Adding product quantities or product $ sales within a qlikview script

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

3 Replies

Re: Adding product quantities or product $ sales within a qlikview script

Perhaps these

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

2) Sum(TOTAL [Sell Price])

Life is so rich, and we need to respect to the life !!!
fgiorgio
Contributor

Re: Adding product quantities or product $ sales within a qlikview script

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...

Re: Adding product quantities or product $ sales within a qlikview script

Looks like this

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

OR

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

Life is so rich, and we need to respect to the life !!!
Community Browser