Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating and presenting a percentage column

Hi

I am in need of help.

I will try to explain my questions in an example:

Example: I have data from a company of their salesmen and how much they sell in a table. I would like to add a column which presents how much they are selling relative the total amount of sales as a percentage. How do I do this?

Thanx 😃

1 Reply
Not applicable
Author

Hi,

use TOTAL qualifier.

your expression will be something like this:

100*sum(sales)/sum(total sales)

Alex