Range multiplication

[maksim_senin]

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

[deepakk · Accepted solution]

hi Maxim,

I hope the attach application helps you out.

Deepak

[maksim_senin]

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

[alexdataiq]

That's is a very nice use of Math!

The formula used is:

=Exp(Sum(Log(Amount)))

Regards!

[kristeljoymalapitan]

Hi  Deepakk,

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

Thanks

[gnmq]

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.