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

Calculate Margin with variable and fixed costs

Hi.

I am brand new to Qlikview.

I've collected my data with an MySQL Database and it works fine.

I've also started to implement the first dashboard in Qlik Cloud. But now i am struggling with the absolute margin of sales.

I have 4 tables:

BranchesEmployeesOrdersProducts
idididid
energy_costssalarybranch-idselling_price
rental_costsbranch-idbuying-timebuying_price
product-id
quantity
buying-time

The calculation of the margin works like charm with this formula (devision through 100 cuz the values saved as cent):

((Sum(price) - Sum(buying_price)) * Count(quantity)) / 100

How i am able to calculate the absolute margin including the energy costs, rental costs and salary of every employee linked to its branch? The costs and salary counting only once per month.

I was trying with this formula but doesn't work - the margin is higher than the total income:

(((Sum(price) - Sum(buying_price)) * Count(quantity)) - (Sum(energy_costs) + Sum(rental_costs) - Sum(salary)) / 100

Thanks for your help.

Best C

4 Replies
sunny_talwar

Would you be able to share some sample data or a sample application to show the issue?

Not applicable
Author

Hi Sunny,

thanks for attention 🙂

Here is a link to the whole app, i think this help us most - Dropbox - FOM BI.qvf

Thank you a lot, Sunny!

Best C

sunny_talwar

Unfortunately, I won't be able to download from DropBox... would you be able to attach here:

Uploading a Sample

Not applicable
Author

Hi Sunny,

i didn't see the button first. Thank you for your hint.

The app is now available via the Attachment.

Thank you.

Best C