topic To display the percentage in straight Table in QlikView

To display the percentage in straight Table

Anonymous — Thu, 21 Jul 2016 10:27:01 GMT

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

swuehl — Thu, 21 Jul 2016 12:19:32 GMT

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)

Thu, 21 Jul 2016 12:49:00 GMT

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 — Thu, 21 Jul 2016 13:05:04 GMT

Hi,

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

Thanks,

Shiva