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: 
Anonymous
Not applicable

Numerator as one row by Denominator the whole column

Hi GuYS

What's the best way to do in a KPI where i want to take each value from one dimension as the Numerator divided by all the vales in that column as the Denominator? Is it best to do in the script or expression and how?

Regards

8 Replies
Anonymous
Not applicable
Author

Could you explore more with some sample data??

sunny_talwar

Are you trying to do something like this:

Dim1     Val

A          10

B          15

C          25

and in the KPI you are trying to do for A -> 10/50?

For this you can try Sum({<Dim1 = {A}>}Val)/Sum(Val)

If this isn't what you are looking for, please elaborate on what you are looking to do.

Best,

Sunny

Anonymous
Not applicable
Author

like this?

Anonymous
Not applicable
Author

I guess, he is asking for Val=10 as Numerator and sum(Val)=50 as Denominator...

If yes, try with total:

sum(Val)/sum(total Val)

simondachstr
Luminary Alumni
Luminary Alumni

sum(Column)/sum(total Column) ?

sunny_talwar

Thanks for pointing that out Balraj. The expression was suppose to do 10/50, but I mistakenly wrote 10/25

Anonymous
Not applicable
Author

Thanks guys, i just need to test something else before i can test this as it's not as straight forward as i've posted, i'll elaborate later.

Anonymous
Not applicable
Author

It seems, you were playing with us