topic Sum(1) in QlikView https://community.qlik.com/t5/QlikView/Sum-1/m-p/464392#M173453 <HTML><HEAD></HEAD><BODY><P>Temp1:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID,</P><P> <SPAN style="color: #ff0000;"><STRONG> Sum(1) </STRONG></SPAN> as TempId</P><P>Resident DimTemporary2</P><P>Group By ID;</P><P>Drop Field TempId;</P><P></P><P>Left Join (Temp1) </P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rowno()&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;as TempId</P><P>Resident Temp1;</P><P></P><P>What's the meaning of sum(1)?</P></BODY></HTML> Mon, 24 Dec 2012 14:16:59 GMT farolito20 2012-12-24T14:16:59Z Sum(1) https://community.qlik.com/t5/QlikView/Sum-1/m-p/464392#M173453 <HTML><HEAD></HEAD><BODY><P>Temp1:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID,</P><P> <SPAN style="color: #ff0000;"><STRONG> Sum(1) </STRONG></SPAN> as TempId</P><P>Resident DimTemporary2</P><P>Group By ID;</P><P>Drop Field TempId;</P><P></P><P>Left Join (Temp1) </P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rowno()&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;as TempId</P><P>Resident Temp1;</P><P></P><P>What's the meaning of sum(1)?</P></BODY></HTML> Mon, 24 Dec 2012 14:16:59 GMT https://community.qlik.com/t5/QlikView/Sum-1/m-p/464392#M173453 farolito20 2012-12-24T14:16:59Z Re: Sum(1) https://community.qlik.com/t5/QlikView/Sum-1/m-p/464393#M173454 <HTML><HEAD></HEAD><BODY><P>That's used as a counter of an ID, so TempId is the counter of ID in this table, but that code is wrong, I think there is no sense on that. That left join is wrong...</P></BODY></HTML> Wed, 26 Dec 2012 17:36:02 GMT https://community.qlik.com/t5/QlikView/Sum-1/m-p/464393#M173454 chematos 2012-12-26T17:36:02Z