# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor III

## how to calculate percentage for each row

Hi All,

How to calculate percentage for each row i mean ,let say if data is like below

plant  xxx   yyy   zzz    vvvv

mah    10      20     20       40

try      20       30      40      50

what i am looking is

plant  xxx                               yyy                                          zzz                                                   vvv

mah   10/10+20+20+40            20/10+20+20+40                      20/10+20+20+40                               40/10+20+20+40

try       20/20+30+40+50            30/20+30+40+50                     40/20+30+40+50                             50/20+30+40+50

so each row should have 100%

thanks

1 Solution

Accepted Solutions
MVP

## Re: how to calculate percentage for each row

You can use like below, May be?

Sum(Sales) / Sum(Total Sales)

OR

Sum(Sales)/Sum(TOTAL <plant> Sales)

5 Replies
Contributor III

## Re: how to calculate percentage for each row

plant  xxx                               yyy                                          zzz                             vvv

mah   10/10+20+20+40            20/10+20+20+40                      20/10+20+20+40          40/10+20+20+40

try       20/20+30+40+50            30/20+30+40+50                    40/20+30+40+50         50/20+30+40+50

MVP

## Re: how to calculate percentage for each row

You can use like below, May be?

Sum(Sales) / Sum(Total Sales)

OR

Sum(Sales)/Sum(TOTAL <plant> Sales)

MVP

## Re: how to calculate percentage for each row

Is this a pivot table with 2 dimensions and 1 expression or a straight table with one dimension and multiple expressions?

Contributor III

## Re: how to calculate percentage for each row

Hello sunny

Pivot table with 2 dimension and 1 expression

Dimension:

1)plant

2)delivery term

MVP

## Re: how to calculate percentage for each row

Then this expression from Anil should work

Sum(Sales)/Sum(TOTAL <plant> Sales)