Calculation Problem

[egoziyan]

G'day

I am trying to calculate inventory cost. \

I've got a product table with the product_id and all the product_parameters (such as model, brand, color, size ...) which are identified as item_value1, item_value2 etc.

I've joined to this table the cost per unit (field - FORCED_PRICE_IS) The Qty is calculated as sum.

When I put the product_id I can see the qty and forced_price_is for each line, But when I use some of the parameters (such as only the Model) I don't see the forced_price_is as we can see in the pic.

I also attaching the qvw

Thanks in advance.

[m_woolf]

When there are duplicate rows with different Prices, QlikView shows the Price as -.

When you add the product id, the rows are no longer duplicates.

[#3]

If you want to display it by using only the model, then maybe use the total keyword

[lironbaram · Accepted solution]

hi

have a look at the attach example

you need to use aggr function because each product in the model have different unit price

[#5]

Nvm, see attached

[egoziyan]

Hi,

Sorry for the late response (time different)  the Aggr did the trick for me

Thanks