Discussion board where members can get started with QlikView.
I need to calculate Totals on a straight table.
Sample straight table -
As a source I have 2 tables -
1. Sales (with Product IDs, quantities and sale prices)
2. Inventory (with unique Product IDs and costs)
Product ID is a dimension.
Total Sales is simply a sum of Sale prices from Sales table
Total Cost is sum (Qty (from sales table)) *Cost (from Inventory table)
Margin is (Sale - Cost) / Sale
Now total margin column is for some reason blank. It shouldn't be a sum of all margins but (Total sales - total cost) / total sales
How can I do that?
I read something about aggr function but not sure I understand how it works.
Go to Solution.
This may be because of expression problems.
Please check the attached the file and check this is what you have written as expressions.
Your logic is correct, so the only reason it may not be working is some sort of syntax error. Make sure your expression look like this:
sum(Sales) //substitute your actual field name
sum(Qty)*sum(Cost) //substitute your actual field names
("Sales" - "Cost")/("Sales") //note that this uses the expression titles set above--they should match exactly
great it worked. it looks like I had an error in my formula. Thansk!