topic Range multiplication in QlikView

Range multiplication

maksim_senin — Thu, 28 Jun 2012 07:07:31 GMT

Hi,

...starting to give up.

Does anybody know whether QV allows to multiply numbers of a set? Like Excel does it via PRODUCT() function.

There is SUM() function which summarizes numbers of a given set, but I would like to multiply them in order to calculate coefficient of inflation for a period. So I need to do it in a chart, not in the script since user can select arbitrary period.

Thanking you in advance.

Best regards,

Maxim

Re: Range multiplication

deepakk — Thu, 28 Jun 2012 07:19:45 GMT

hi Maxim,

I hope the attach application helps you out.

Deepak

Re: Range multiplication

maksim_senin — Thu, 28 Jun 2012 22:38:06 GMT

Hi Deepak,

Looks good! Since ln(a*c) = ln(a) + ln(c), we really can find a*b via exp of sum of ln(a) and ln(b)!

Thanks.

Best regards,
Maxim

Re: Range multiplication

alexdataiq — Thu, 11 Feb 2016 17:29:29 GMT

That's is a very nice use of Math!

The formula used is:

=Exp(Sum(Log(Amount)))

Regards!

Re: Range multiplication

kristeljoymalapitan — Thu, 07 Mar 2019 05:12:49 GMT

Hi Deepakk,

May i see the your example on attached qvw file. I have no qlik view and unable to open the file

Thanks

Re: Range multiplication

gnmq — Wed, 09 Sep 2020 10:53:18 GMT

Hello, Can I check how do I get the calculation by month and product?

Example:

Date, Product, Amount

2020-01-01, ProductA, 0.2

2020-01-31, ProductA, 0.5

The calculated field will be 0.2 * .... * 0.5

I will also have other month and product in the example above.