Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

maxim_senin
Contributor III

Range multiplication

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

1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Re: Range multiplication

hi Maxim,

I hope the attach application helps you out.

Deepak

4 Replies
deepakk
Valued Contributor III

Re: Range multiplication

hi Maxim,

I hope the attach application helps you out.

Deepak

maxim_senin
Contributor III

Re: Range multiplication

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

Highlighted
Partner
Partner

Re: Range multiplication

That's is a very nice use of Math!

The formula used is:

=Exp(Sum(Log(Amount)))


Regards!

kristeljoymalapitan
New Contributor III

Re: Range multiplication

Hi  Deepakk,

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

 

Thanks