Qlik Community

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 
Search instead for 
Did you mean: 
selvapraveen
Contributor II
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,

Follow the below steps,

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

View solution in original post

3 Replies
swuehl
MVP
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,

Follow the below steps,

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

spsrk_84
Creator III
Creator III

Hi,

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

Thanks,

Shiva