topic RangeProd()?? in QlikView

RangeProd()??

Jason_Michaelides — Tue, 29 May 2012 22:46:33 GMT

Hi all,

I know RangeProd() does not exist (currently, I hope!) and that there is an "idea" already raised for this (please vote - http://community.qlik.com/ideas/1105), but I have a requirement to achieve this now...

I am using Above() to get an array of values. I can use RangeSum(Above(Sum(Sales),0,RowNo()) to sum all these values together, but does anyone have any bright ideas how to multiply all the values together?

Thanks,

Jason

Re: RangeProd()??

swuehl — Tue, 29 May 2012 23:12:13 GMT

Hi Jason,

try using

=exp(rangesum(above(log(sum(Sales)),0,rowno())))

Regards,

Stefan

RangeProd()??

Jason_Michaelides — Tue, 29 May 2012 23:42:08 GMT

Dude - we have to meet so I can attach some kind of genius-extracting-device to your head! I saw your previous post on a similar thread but couldn't quite get it to work.

Confession time - although this will certainly be something I will need in the future, this was actually the last piece of a puzzle I needed to solve someone else's challenge... http://community.qlik.com/thread/54368?tstart=0

Thanks again Stefan - and for responding so quickly!

Jason