Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jorditorras
Contributor

How to calculate a relative %

Dear Gurus,

Is it any way to calculate the relative % of the total for each line in a straight table?

For example:

                         Prices            % Participation (the one I want to calculate)

Average Price     5                           5

Price 1                4                           80%                                  

Price 2               10                          200%        

Price 3                1                           20%

Price 4                5                           100%

Thanks!!

Regards,

Jordi

1 Solution

Accepted Solutions
MVP
MVP

Re: How to calculate a relative %

Check !

You can also use expression as

SUM(Value)/Avg({1}total Value)

View solution in original post

7 Replies
Chanty4u
Esteemed Contributor III

Re: How to calculate a relative %

u can give ur exp 

sum( prices)

and go to number tab and chk  show in %

Chanty4u
Esteemed Contributor III

Re: How to calculate a relative %

or else in expression tab   u will find relative option u can chk there

Employee
Employee

Re: How to calculate a relative %

maybe (you didn´t uploaded your data or expressions)

sum(prices) / sum(total prices)

MVP
MVP

Re: How to calculate a relative %

Check !

You can also use expression as

SUM(Value)/Avg({1}total Value)

View solution in original post

Re: How to calculate a relative %

What expression are you using.

Regards

Anand

Re: How to calculate a relative %

You are using variable also

Ex:-

Let vAvg = 5

Dim:- Price

Expre:- (SUM(Value)/ $(vAvg))

Obj.PNG

Regards

Anand

jorditorras
Contributor

Re: How to calculate a relative %

Thank you! It solved my question!

Regards,

Jordi