Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jorditorras
Creator
Creator

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

Check !

You can also use expression as

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

View solution in original post

7 Replies
Chanty4u
MVP
MVP

u can give ur exp 

sum( prices)

and go to number tab and chk  show in %

Chanty4u
MVP
MVP

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

Clever_Anjos
Employee
Employee

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

sum(prices) / sum(total prices)

MK_QSL
MVP
MVP

Check !

You can also use expression as

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

its_anandrjs

What expression are you using.

Regards

Anand

its_anandrjs

You are using variable also

Ex:-

Let vAvg = 5

Dim:- Price

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

Obj.PNG

Regards

Anand

jorditorras
Creator
Creator
Author

Thank you! It solved my question!

Regards,

Jordi