Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikhub
Contributor III
Contributor III

ques

how to calculate the profit , margin,current sales vs previous sales,sales growth  in Qlik sense ?

anyone can reply me as formula for dashboard

Labels (5)
7 Replies
micheledenardi
Specialist II
Specialist II

Sum(Profit) 
Sum(Margin)
Sum(Sales)

Sorry but QlikCommunity cannot help you on these topics since profit/margins/sales depends from how your company is setted.

Please face these arguments with your controlling department in order to understand where pick the correct data from your ERP and how to built the correct formulas.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Qlikhub
Contributor III
Contributor III
Author

i want only formula ?

micheledenardi
Specialist II
Specialist II

Sales is generally the [Invoiced Amount].

Margin is generally obtained by [Revenues-Costs].

Profit is generally [Revenues]- [Expenses].

 

As i wrote you need to discuss with your controlling/sales department.

We cannot write you the exact fomulas for 2 reasons:

1) We don't know your company's financial rules.

2) We don't know how your datamodel is.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Qlikhub
Contributor III
Contributor III
Author

i want only formula basics

micheledenardi
Specialist II
Specialist II

Sales is generally the [Invoiced Amount].

Margin is generally obtained by [Revenues-Costs].

Profit is generally [Revenues]- [Expenses].

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Qlikhub
Contributor III
Contributor III
Author

thanks

micheledenardi
Specialist II
Specialist II

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.