Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Branches | Employees | Orders | Products |
---|---|---|---|
id | id | id | id |
energy_costs | salary | branch-id | selling_price |
rental_costs | branch-id | buying-time | buying_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
Would you be able to share some sample data or a sample application to show the issue?
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
Unfortunately, I won't be able to download from DropBox... would you be able to attach here:
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