Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi Maxim,
I hope the attach application helps you out.
Deepak
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
That's is a very nice use of Math!
The formula used is:
=Exp(Sum(Log(Amount)))
Regards!
Hi Deepakk,
May i see the your example on attached qvw file. I have no qlik view and unable to open the file
Thanks
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.