Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

To display the percentage in straight Table

Have a below straight  table

Product      sales

A          3

B          20

c          50

The sale is the sum of Total sale , now need to have a colum in the same table showing the percentage of sales

the table should look like

Product      Sale     Sales%

A          30          4%

b          20          5%

c          50          50%

the sales% should show the percentage of sales of A in the total sales

how can this be done

1 Solution

Accepted Solutions
Not applicable
Author

Hi SelvaPraveen,

Step1: Write an expression like below in, Expressions tab

Sum(Sales)/Sum(Total(Sales))

Step 2: Goto Stright Table Properties ->Number tab and set below Number format settings for above expression,

Select 'Number'

Check 'Show in Percent(%)'

Thanks,

Narsi

3 Replies
MVP

Could you please elaborate further how you calculate your sales%, e.g why Product A results to 4%?

I assume you need to use the TOTAL qualifier (maybe with a field list and / or set Analysis), something like

=Sum(Sales) / Sum(TOTAL Sales)

Not applicable
Author

Hi SelvaPraveen,

Step1: Write an expression like below in, Expressions tab

Sum(Sales)/Sum(Total(Sales))

Step 2: Goto Stright Table Properties ->Number tab and set below Number format settings for above expression,

Select 'Number'

Check 'Show in Percent(%)'

Thanks,

Narsi

Creator III

Hi,

Create another expression called Sales% similar to Sales and check the Relative option provided.

Thanks,

Shiva

Community Browser