11 Replies Latest reply: Nov 21, 2017 6:25 AM by Anil Samineni

# how to get % of a sum figure in qlik

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

• ###### Re: how to get % of a sum figure in qlik

Perhaps this?

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

• ###### Re: how to get % of a sum figure in qlik

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

Regards

• ###### Re: how to get % of a sum figure in qlik

Actually the production is a variable

dimension is city

How can i construct the statement.

• ###### Re: how to get % of a sum figure in qlik

Can you define your variable also vPremiumYTD

• ###### Re: how to get % of a sum figure in qlik

The Production is represented as vPremiumYTD

and the City is an dimension.

• ###### Re: how to get % of a sum figure in qlik

May be this?