Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Struggling with straight table totals

Hello,

I need to calculate Totals on a straight table.

Sample straight table -

ProductTotal salesTotal cost
Margin

1000800
-
Product1500400
20%
Product2300250
17%
Product3200150
25%

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.

Many thanks!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi

This may be because of expression problems.

Please check the attached the file and check this is what you have written as expressions.

View solution in original post

3 Replies
vgutkovsky
Master II
Master II

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:

Sales

sum(Sales) //substitute your actual field name

Cost

sum(Qty)*sum(Cost) //substitute your actual field names

Margin

("Sales" - "Cost")/("Sales") //note that this uses the expression titles set above--they should match exactly

Regards,

Vlad

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi

This may be because of expression problems.

Please check the attached the file and check this is what you have written as expressions.

Not applicable
Author

great it worked. it looks like I had an error in my formula. Thansk!