topic Re: Calculate Savings on the Item level - average cost in QlikView

Calculate Savings on the Item level - average cost

Thu, 19 Mar 2015 12:34:15 GMT

Hi there,

Basically I have list of Items with Sales Qty, Sales Period, Cost Price and Cost Centre. I am comparing average Cost Price between two periods and then multiplying difference by current Sales Qty to see any Savings due to Cost Price change.

Please see attached file - "item level v2"

You can see that in the table "Saving by Item" all Savings numbers and Total number (sum) looks fine. But using the same calculations in the "Saving by Cost Centre" table the numbers are totally different - special Total number.

For example Cost Centre 106 shows £2,005,968. But when you actually select 106 the top table shows £301 - which is correct.

My question is, how can I display numbers based on the Item level in the "Savings by Cost Centre"? How to calculate correct savings on the different levels?

Thank you for any response,

Dave

Re: Calculate Savings on the Item level - average cost

Thu, 19 Mar 2015 12:51:47 GMT

Hi,

All expressions are wrong way. you can keep set analysis properly.

Re: Calculate Savings on the Item level - average cost

Thu, 19 Mar 2015 12:54:29 GMT

Hi, I'm sorry, bu not sure what do you mean?

Re: Calculate Savings on the Item level - average cost

Gysbert_Wassenaar — Thu, 19 Mar 2015 12:59:56 GMT

See attached example.

Re: Calculate Savings on the Item level - average cost

Thu, 19 Mar 2015 15:42:59 GMT

Hi there,

I can see that total numbers work fine. But for example in the "Saving by Cost Centre" table you have £-13,619 and when actually I select 106 it should be £301. I would like to see that number in the Cost Centre view. Is it possible?