# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

## Re: Numerator as one row by Denominator the whole column

Could you explore more with some sample data??

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

Esteemed Contributor

## Re: Numerator as one row by Denominator the whole column

like this?

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)

Valued Contributor III

## Re: Numerator as one row by Denominator the whole column

sum(Column)/sum(total Column) ?

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

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.

Esteemed Contributor

## Re: Numerator as one row  by Denominator the whole column

It seems, you were playing with us