topic Re: Multiplication single row in QlikView https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050589#M352726 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD reg,</STRONG></P><P><STRONG>&nbsp; Date(start + IterNo() - 1) as date,</STRONG></P><P><STRONG>&nbsp; pcakc</STRONG></P><P><STRONG>While Date(start + IterNo() - 1) &lt;= end;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>reg, start, end, pcakc</STRONG></P><P><STRONG>123456, 01.01.16, 10.01.16, i256</STRONG></P><P><STRONG>789101,&nbsp; 03.01.16, 12.01.16, i212</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114923_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 17 Feb 2016 09:24:05 GMT sunny_talwar 2016-02-17T09:24:05Z Multiplication single row https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050588#M352725 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need help with multiplication in LOAD script.</P><P></P><P>I have source table with about 1000 <STRONG>[reg]</STRONG>. Each <STRONG>[reg]</STRONG> has <STRONG>[start]</STRONG> and <STRONG>[end]</STRONG> date and pcakc. I need multiplication of each <STRONG>[reg]</STRONG> row for <STRONG>[start]</STRONG>-<STRONG>[end]</STRONG> range date.</P><P></P><P><SPAN style="; color: #575757; text-decoration: underline;"><STRONG>Source table:</STRONG></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 249px;"><TBODY><TR><TD class="xl66" height="21" width="64"><STRONG>reg</STRONG></TD><TD class="xl67" style="border-left: none;" width="64"><STRONG>start</STRONG></TD><TD class="xl67" style="border-left: none;" width="57"><STRONG>end</STRONG></TD><TD class="xl68" style="border-left: none;" width="64"><STRONG>pcakc</STRONG></TD></TR><TR><TD class="xl63" height="20">123456</TD><TD class="xl64" style="border-left: none;"><SPAN style="color: #99cc00;"><STRONG>01.01.16</STRONG></SPAN></TD><TD class="xl65" style="border-left: none;"><SPAN style="color: #ff9900;"><STRONG>10.01.16</STRONG></SPAN></TD><TD class="xl63" style="border-left: none;">i256</TD></TR></TBODY></TABLE><P></P><P><SPAN style="text-decoration: underline;"><STRONG> Result</STRONG></SPAN>:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 185px;"><TBODY><TR><TD class="xl69" height="21" width="64"><STRONG>reg</STRONG></TD><TD class="xl70" style="border-left: none;" width="64"><STRONG>date</STRONG></TD><TD class="xl72" style="border-left: none;" width="57"><STRONG>pcakc</STRONG></TD></TR><TR><TD class="xl68" height="20">123456</TD><TD class="xl71" style="border-left: none;"><SPAN style="color: #99cc00;"><STRONG>01.01.16</STRONG></SPAN></TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">02.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">03.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">04.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">05.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">06.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">07.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">08.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl66" style="border-top: none; border-left: none;">09.01.16</TD><TD class="xl68" style="border-left: none;">i256</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">123456</TD><TD class="xl67" style="border-top: none; border-left: none;"><SPAN style="color: #ff9900;"><STRONG>10.01.16</STRONG></SPAN></TD><TD class="xl68" style="border-left: none;">i256</TD></TR></TBODY></TABLE><P>thx.</P></BODY></HTML> Wed, 17 Feb 2016 08:52:33 GMT https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050588#M352725 janturon 2016-02-17T08:52:33Z Re: Multiplication single row https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050589#M352726 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD reg,</STRONG></P><P><STRONG>&nbsp; Date(start + IterNo() - 1) as date,</STRONG></P><P><STRONG>&nbsp; pcakc</STRONG></P><P><STRONG>While Date(start + IterNo() - 1) &lt;= end;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>reg, start, end, pcakc</STRONG></P><P><STRONG>123456, 01.01.16, 10.01.16, i256</STRONG></P><P><STRONG>789101,&nbsp; 03.01.16, 12.01.16, i212</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114923_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 17 Feb 2016 09:24:05 GMT https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050589#M352726 sunny_talwar 2016-02-17T09:24:05Z Re: Multiplication single row https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050590#M352727 <HTML><HEAD></HEAD><BODY><P>thank you very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 17 Feb 2016 09:45:56 GMT https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050590#M352727 janturon 2016-02-17T09:45:56Z Re: Multiplication single row https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050591#M352728 <HTML><HEAD></HEAD><BODY><P>No problem. I am glad I was able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 17 Feb 2016 09:55:23 GMT https://community.qlik.com/t5/QlikView/Multiplication-single-row/m-p/1050591#M352728 sunny_talwar 2016-02-17T09:55:23Z