topic Re: scripting in QlikView https://community.qlik.com/t5/QlikView/scripting/m-p/1441639#M432527 <HTML><HEAD></HEAD><BODY><P>Hi kulwant,</P><P></P><P>Say you have the table:</P><P></P><P>Data:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; no.</P><P>From [Whatever];</P><P></P><P>join (Data)</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(no.) as Sumation</P><P>resident Data;</P><P></P><P>That will put the total sum at every row of your data.</P><P></P><P>Felipe.</P></BODY></HTML> Fri, 29 Sep 2017 12:33:17 GMT felipedl 2017-09-29T12:33:17Z scripting https://community.qlik.com/t5/QlikView/scripting/m-p/1441638#M432526 <HTML><HEAD></HEAD><BODY><P>Hi all&nbsp; </P><P></P><P>this is the data which i have</P><P></P><TABLE border="0" cellspacing="0"><TBODY><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">name</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">no.</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">abc</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">45</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">ddd</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">130.5</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">eee</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">22</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">rrr</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">12</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">ttt</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">yyy</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">2.4</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">bbb</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">1</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>i need output (sum of no.)</P><P></P><P>&nbsp; </P><TABLE border="0" cellspacing="0"><TBODY><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">name</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">no.</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">output</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">abc</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">45</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">ddd</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">130.5</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">eee</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">22</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">rrr</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">ttt</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">9</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">yyy</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">2.4</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR><TR><TD align="center" height="18" valign="bottom"><SPAN style="color: #000000;">bbb</SPAN></TD><TD align="center" valign="bottom"><SPAN style="color: #000000;">1</SPAN></TD><TD align="right" valign="bottom"><SPAN style="color: #000000;">221.9</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>i want to achieve this in script </P><P></P><P>regards</P></BODY></HTML> Fri, 29 Sep 2017 12:21:41 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/1441638#M432526 Anonymous 2017-09-29T12:21:41Z Re: scripting https://community.qlik.com/t5/QlikView/scripting/m-p/1441639#M432527 <HTML><HEAD></HEAD><BODY><P>Hi kulwant,</P><P></P><P>Say you have the table:</P><P></P><P>Data:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; no.</P><P>From [Whatever];</P><P></P><P>join (Data)</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(no.) as Sumation</P><P>resident Data;</P><P></P><P>That will put the total sum at every row of your data.</P><P></P><P>Felipe.</P></BODY></HTML> Fri, 29 Sep 2017 12:33:17 GMT https://community.qlik.com/t5/QlikView/scripting/m-p/1441639#M432527 felipedl 2017-09-29T12:33:17Z