Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Savings on the Item level - average cost

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

4 Replies
Not applicable

Hi,

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

Not applicable

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

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
Not applicable

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?