# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## 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

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

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