# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor II

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

11 Replies
MVP

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

Regards,
Prashant Sangle
New Contributor II

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

MVP

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

New Contributor II

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

The Production is represented as vPremiumYTD

and the City is an dimension.

MVP

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

May be this?

New Contributor II

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

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

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

TOTAL is qualifier

Search for topics and videos - Qlik | Help

Regards

Regards,
Prashant Sangle
MVP

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

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