Skip to main content

New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Percentage Calcualtion.

Hi Qlik,

I need this calculation in a Percentage Column as 'Net Profit %' how to achieve this. thanks

 

= sum(revenue) - sum(burdened_cost)
/
sum(revenue)

1 Solution

Accepted Solutions
Øystein_Kolsrud
Employee
Employee

Aren't you simply looking for this expression?

(Sum(revenue)-Sum(cost))/Sum(revenue)

If it's how to format the fraction as a percentage you are really asking for, then you do that in the measure properties. Click on "Number formatting", choose "Number" in the drop-down menu, then choose a percentage formatting of your choice in the "Simple" drop-down menu.

View solution in original post

5 Replies
Øystein_Kolsrud
Employee
Employee

I'm not sure how your burdened_cost value relates to the revenue for each table row compared to the total revenue, but typically a percentage of the total would be calculated like this:

Sum(Sales)/Sum(total Sales)

Here's a similar thread on the topic:

https://community.qlik.com/t5/App-Development/Calculating-percentage-of-total-by-dimension/td-p/1198...

stevejoyce
Specialist II
Specialist II

What is your qlik related question?  How to format in percent or what your calculation should be?

MuraliPrasath
Creator III
Creator III
Author

Hi,

My profit column should be like sum(revenue)-sum(cost) divided by Sum(revenue).

I need this expression should be as profit % coloum. 

Hope you are clear. 

First I want to minus two values and then divided by revenue. 

thanks for you help!

 

Øystein_Kolsrud
Employee
Employee

Aren't you simply looking for this expression?

(Sum(revenue)-Sum(cost))/Sum(revenue)

If it's how to format the fraction as a percentage you are really asking for, then you do that in the measure properties. Click on "Number formatting", choose "Number" in the drop-down menu, then choose a percentage formatting of your choice in the "Simple" drop-down menu.

MuraliPrasath
Creator III
Creator III
Author

Yes! thanks you 🙂