topic Regarding multiplication in a row in QlikView https://community.qlik.com/t5/QlikView/Regarding-multiplication-in-a-row/m-p/353565#M1173841 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Lets say i have to collums in a excel file.</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160</P><P>450&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>950&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160</P><P></P><P>I then what i expression that multiplies (500*160+450*160+950*160)=304500</P><P></P><P>I have now tested =sum(A)*sum(B) but ofc that gives me the wrong answer since it sums the row before multipling.</P><P></P><P>Thanksfull for all answers!&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 16 May 2012 09:13:38 GMT 2012-05-16T09:13:38Z Regarding multiplication in a row https://community.qlik.com/t5/QlikView/Regarding-multiplication-in-a-row/m-p/353565#M1173841 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Lets say i have to collums in a excel file.</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160</P><P>450&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>950&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 160</P><P></P><P>I then what i expression that multiplies (500*160+450*160+950*160)=304500</P><P></P><P>I have now tested =sum(A)*sum(B) but ofc that gives me the wrong answer since it sums the row before multipling.</P><P></P><P>Thanksfull for all answers!&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 16 May 2012 09:13:38 GMT https://community.qlik.com/t5/QlikView/Regarding-multiplication-in-a-row/m-p/353565#M1173841 2012-05-16T09:13:38Z Regarding multiplication in a row https://community.qlik.com/t5/QlikView/Regarding-multiplication-in-a-row/m-p/353566#M1173842 <HTML><HEAD></HEAD><BODY><P>Ohh the solution is ofc sum(A*B)! </P><P></P><P>Thanks anyways!</P></BODY></HTML> Wed, 16 May 2012 09:37:57 GMT https://community.qlik.com/t5/QlikView/Regarding-multiplication-in-a-row/m-p/353566#M1173842 2012-05-16T09:37:57Z