Multiple field values in one column

[naveen341]

Hi 

HOw can we multiply field values in one column in Qlikview expression

example

Expected o/p is the product of all numerators: 34*67*86

ID	Numerator	Expected O/P
13435	34	195908
4646	67	195908
6337	86	195908

Thanks in Advance

[sunny_talwar · Accepted solution]

Try this

=exp(Sum(log(Numerator)))

[naveen341]

Thanks sum this helped.

One more thing

How do i get (34*64*87) power 1/ count(Numerator)

[sunny_talwar]

This

=Pow(exp(Sum(log(Numerator))), (1/Count(Numerator)))

[naveen341]

Hey sunny if i have many values exp(Sum(log(Numerator))) is showing inft.
is there any other way we can find product

[sunny_talwar]

Any calculation which gives inft. based on the above expression.... will give inft. based on other methods as well...

Out of curiosity, what are you multiplying... can you share a snapshot?

[naveen341]

Please find the attached screen shot i want to multiply all the values in second row

[sunny_talwar]

I am not seeing infinity for either of the expressions I mentioned above

Are you sure you are using the expression correctly?

[naveen341]

This is the expression i am using

[sunny_talwar]

If you export this chart into Excel and perform this multiplication in Excel, are you able to see a result? My guess is that you have a lot of rows and multiplication can very quickly become a very very big number... a number which QlikView (or even Excel) may not be able to display.

But this is just my theory, let's see what other experts have to say about this

@rwunderlich

@marcus_sommer

@Oleg_Troyansky