topic Re: sumproduct as Excel in QlikView

sumproduct as Excel

Wed, 26 Mar 2014 12:39:06 GMT

Hi people, I need your help with this... see the pic!! Thanks you!!

Marina

Re: sumproduct as Excel

jvishnuram — Wed, 26 Mar 2014 12:44:29 GMT

Hi Marina,

Try This.,

Rangesum(

Above(

Sum(column(1))

Sum(column(2))

,0,NoOfRows()))

Re: sumproduct as Excel

Wed, 26 Mar 2014 12:54:47 GMT

Hi Vishnu, thanks for answering my question, but the numbers are in the same column... so your expression with column(1) and column(2) doesn't function, there are only 1 column... there are operations by rows, not by columns..

Re: sumproduct as Excel

jvishnuram — Wed, 26 Mar 2014 12:57:30 GMT

Hi Marina,

Then its so simple use column(1) alone in that expression.

Re: sumproduct as Excel

fernando_tonial — Wed, 26 Mar 2014 13:34:01 GMT

Hi Marina,

Maybe you try like attach.

Re: sumproduct as Excel

Wed, 26 Mar 2014 13:55:01 GMT

Thanks Fernando and Vishnu, here I'm attaching the Excel file, look at the red cell, see the function that I'm using, I need this function on Qlikview.

Re: sumproduct as Excel

Wed, 26 Mar 2014 13:57:48 GMT

how can i attach an xls file??

Re: sumproduct as Excel

Wed, 26 Mar 2014 14:04:04 GMT

Re: sumproduct as Excel

jvishnuram — Wed, 26 Mar 2014 14:15:03 GMT

Use advanced editor in the right top.

Re: sumproduct as Excel

Wed, 26 Mar 2014 14:21:48 GMT

thanks, i've attached there: http://community.qlik.com/message/496126#496126