Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
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

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

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

kunkumnaveen
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
MVP

Re: how to calculate percentage for each row

Then this expression from Anil should work

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

Community Browser