topic Re: Re: Calculation Problem in QlikView

Calculation Problem

egoziyan — Tue, 12 Aug 2014 13:33:29 GMT

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.

Re: Calculation Problem

m_woolf — Tue, 12 Aug 2014 18:21:56 GMT

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.

Re: Calculation Problem

Tue, 12 Aug 2014 18:26:19 GMT

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

Re: Calculation Problem

lironbaram — Tue, 12 Aug 2014 18:29:39 GMT

have a look at the attach example

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

Re: Re: Calculation Problem

Tue, 12 Aug 2014 18:31:19 GMT

Nvm, see attached

Re: Calculation Problem

egoziyan — Wed, 13 Aug 2014 14:40:44 GMT

Hi,

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

Thanks