how to get % of a sum figure in qlik

[pashok75]

Dears

I need to get the % of production based on the sum figures of 4 dimensions.

CITY	PRODUCTION	%
A	1000	16.66667
B	2000	33.33333
C	1000	16.66667
D	2000	33.33333
TOTAL	6000	100

From the above table from the production figures i need to calculate the contribution of each city. How can I do it qlik chart.

Ashok

[Anil_Babu_Samineni]

Perhaps this?

(Sum(PRODUCTION) / Sum(TOTAL PRODUCTION))*1000

[PrashantSangle]

Sum(Production)/Sum({<City=>}Total Production).

Regards

[pashok75]

Actually the production is a variable

dimension is city

Production is $(vPremiumYTD)

How can i construct the statement.

[Anil_Babu_Samineni]

Can you define your variable also vPremiumYTD

[pashok75]

The Production is represented as vPremiumYTD

and the City is an dimension.

[Anil_Babu_Samineni]

May be this?

(Sum($(vPremiumYTD)) / Sum(TOTAL $(vPremiumYTD)))*1000

[pashok75]

Hi Anil,

the TOTAL you refer to any builtin QLIK field  as there is no field by name TOTAL. The dimension field name is CITY

[PrashantSangle]

use help menu.

TOTAL is qualifier

Search for topics and videos - Qlik | Help

Regards

[Anil_Babu_Samineni]

Let's consider this as example

Name, Sales

A, 10

B, 20

C, 30

Sum(Sales) Returns

A, 10

B, 20

C, 30

Sum(TOTAL Sales)

A, 60

B, 60

C, 60