Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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 😃

Labels (1)
1 Reply
Not applicable
Author

Hi,

use TOTAL qualifier.

your expression will be something like this:

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

Alex