topic Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ? in QlikView

Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 09:51:43 GMT

Hello.

I'm trying to find the way to calculate the column multiplication

As I understand I need a function such as Sum but It shuld multiply operands instead of sum them.

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

sujeetsingh — Mon, 27 Jan 2014 10:01:27 GMT

Alek ,

It seems that you want the iteratin here .

Can you give the sample of your doc.

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 10:04:24 GMT

Hi Aleksander

you can use sum(X1 * X2 * Xn)

the expression will perform first (X1 * X2 * Xn) then sum the result along the dimensions

best regards

Chris

Re: Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 10:26:22 GMT

Here is an example: I have a dataset: 1, 2, 4, 5 and I should get 1 * 2 * 4 * 5 = 40

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 10:27:06 GMT

what do you mean by "multiply operands instead of sum them."

Can you please send us a sample file or sample data.

Thanks,

Angad

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

tresB — Mon, 27 Jan 2014 11:25:29 GMT

I have found a work around:

=$(=Concat(F1,'*'))

PFA

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 11:39:11 GMT

Please Try "fact(Max(F1))"

Kind Regards,

Footsie

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Mon, 27 Jan 2014 11:45:17 GMT

coool tresesco Loved the work around

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Fri, 31 Jan 2014 15:53:03 GMT

It's not working on "BIG" data

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

swuehl — Fri, 31 Jan 2014 16:05:00 GMT

You can do it like

= Exp(Sum(Log( F1 )))

F1 being your field name

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Fri, 31 Jan 2014 16:10:38 GMT

What about Avg(n) * Count(n)

OK, you may need to round it a bit, but it's close

John

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Fri, 31 Jan 2014 16:12:34 GMT

swuehl a écrit:

You can do it like

= Exp(Sum(Log( F1 )))

F1 being your field name

Yep, this should work.

Provided there's only positive values in your column. Otherwise, for example :

= If(Sum((F1=0))=0, Exp(Sum(Log( Fabs( F1 )))) * (1-2*Mod(Sum((F1>=0)),2)),0)

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Fri, 31 Jan 2014 16:31:43 GMT

UnF**ingBelievelable

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

Fri, 31 Jan 2014 16:34:00 GMT

You said it !!!

Re: Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

tresB — Mon, 03 Feb 2014 05:17:29 GMT

Perhaps, you would want to add a 'DISTINCT' in the expression like:

=$(=Concat( distinct F1,'*'))