Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakwinder
Contributor III

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
balrajahlawat
Esteemed Contributor

Re: Numerator as one row by Denominator the whole column

Could you explore more with some sample data??

MVP
MVP

Re: Numerator as one row by Denominator the whole column

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

balrajahlawat
Esteemed Contributor

Re: Numerator as one row by Denominator the whole column

like this?

balrajahlawat
Esteemed Contributor

Re: Numerator as one row by Denominator the whole column

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
Valued Contributor III

Re: Numerator as one row by Denominator the whole column

sum(Column)/sum(total Column) ?

MVP
MVP

Re: Numerator as one row by Denominator the whole column

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

lakwinder
Contributor III

Re: Numerator as one row by Denominator the whole column

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.

balrajahlawat
Esteemed Contributor

Re: Numerator as one row  by Denominator the whole column

It seems, you were playing with us