topic Re: LOAD CALCULATE in QlikView https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745460#M662387 <HTML><HEAD></HEAD><BODY><P>thanks</P><P></P><P>and if the situation is this?</P><P><SPAN style="font-size: 8pt;">a:<BR /><BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /><BR /> id, DATE_FROM, DATE_FROM_DATE_TO, IN_PORTFOLIO, GO<BR /> 1, 201506, 201506|201507, 9 ,1 <BR /> 2, 201506, 201506|201508, 9 ,6 <BR /> 3, 201506, 201506|201508, 9 ,6 <BR /> 4, 201506, 201506|201508, 9 ,6 <BR /> 5, 201506, 201506|201509, 9 ,2 <BR /> 6, 201507, 201507|201508, 11, 7 <BR /> 7, 201507, 201507|201509, 11 ,4 <BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /></SPAN></P></BODY></HTML> Wed, 04 Feb 2015 17:58:53 GMT 2015-02-04T17:58:53Z LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745453#M662380 <HTML><HEAD></HEAD><BODY><P>Hi community.</P><P></P><P>I have this situation</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 376px; border-collapse: collapse;"> <TBODY><TR style="height: 12.75pt;"> <TD height="17" style="border: 0.5pt solid gainsboro; width: 56pt; height: 12.75pt; background-color: whitesmoke;" width="75"><STRONG style="color: #333333; font-family: Tahoma;">DATE_FROM</STRONG></TD> <TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 102pt; background-color: whitesmoke;" width="136"><STRONG style="color: #333333; font-family: Tahoma;">DATE_FROM_DATE_TO</STRONG></TD> <TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 67pt; background-color: whitesmoke;" width="89"><STRONG style="color: #333333; font-family: Tahoma;">IN_PORTFOLIO</STRONG></TD> <TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 17pt; background-color: whitesmoke;" width="23"><STRONG style="color: #333333; font-family: Tahoma;">GO</STRONG></TD> <TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 40pt; background-color: whitesmoke;" width="53"><SPAN style="color: #333333; font-family: Tahoma;"><SPAN style="color: #575757; font-family: Arial;">SPECT</SPAN> </SPAN></TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201507</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">1</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">8</SPAN></TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201508</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">6</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2</SPAN></TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201509</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">0</SPAN></TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507|201508</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">7</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">4</SPAN></TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507|201509</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">4</SPAN></TD> <TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">0</SPAN></TD> </TR> </TBODY></TABLE><P></P><P>I have all of this fields, but i need to calculate in script SPECT field.</P><P></P><P>Can sameone help me. </P></BODY></HTML> Wed, 04 Feb 2015 17:28:22 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745453#M662380 2015-02-04T17:28:22Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745454#M662381 <HTML><HEAD></HEAD><BODY><P>Is this what you want? PFA</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Wed, 04 Feb 2015 17:35:57 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745454#M662381 sunny_talwar 2015-02-04T17:35:57Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745455#M662382 <HTML><HEAD></HEAD><BODY><P><STRONG>RESULT</STRONG></P><P></P><P><IMG alt="1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77155_1.jpg" style="height: auto; width: auto;" /></P><P><STRONG>SCRIPT</STRONG></P><P><EM>a:</EM></P><P>LOAD DATE_FROM, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; DATE_FROM_DATE_TO, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; IN_PORTFOLIO, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; GO</P><P>&nbsp;&nbsp;&nbsp;&nbsp; //SPECT</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2061" data-containertype="14" data-objectid="150786" data-objecttype="1" href="http://community.qlik.com/thread/150786">http://community.qlik.com/thread/150786</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @1);</P><P></P><P>b:</P><P>load * ,</P><P>&nbsp; if(DATE_FROM=peek(DATE_FROM), peek(SPECT) - GO, IN_PORTFOLIO - GO) as SPECT</P><P>Resident</P><P>&nbsp; a</P><P>order by</P><P>&nbsp; DATE_FROM, </P><P>&nbsp;&nbsp;&nbsp; DATE_FROM_DATE_TO;</P></BODY></HTML> Wed, 04 Feb 2015 17:37:31 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745455#M662382 maxgro 2015-02-04T17:37:31Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745456#M662383 <HTML><HEAD></HEAD><BODY><P>You forgot!</P><P>Drop table a;</P><P>regads!</P></BODY></HTML> Wed, 04 Feb 2015 17:41:19 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745456#M662383 2015-02-04T17:41:19Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745457#M662384 <HTML><HEAD></HEAD><BODY><P>vero, grazie</P></BODY></HTML> Wed, 04 Feb 2015 17:43:03 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745457#M662384 maxgro 2015-02-04T17:43:03Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745458#M662385 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DATE_FROM,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DATE_FROM_DATE_TO,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IN_PORTFOLIO,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; GO,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; rangesum(-GO, If(DATE_FROM=previous(DATE_FROM),peek('SPECT'),IN_PORTFOLIO)) as SPECT</P><P>FROM ....</P></BODY></HTML> Wed, 04 Feb 2015 17:46:30 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745458#M662385 Gysbert_Wassenaar 2015-02-04T17:46:30Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745459#M662386 <HTML><HEAD></HEAD><BODY><P>and it the situation is it?</P><P></P><P><SPAN style="font-size: 8pt;">a:<BR /> <BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> <BR /> id, DATE_FROM, DATE_FROM_DATE_TO, IN_PORTFOLIO, GO<BR /> 1, 201506, 201506|201507, 9 ,1 <BR /> 2, 201506, 201506|201508, 9 ,6 <BR /> 3, 201506, 201506|201508, 9 ,6 <BR /> 4, 201506, 201506|201508, 9 ,6 <BR /> 5, 201506, 201506|201509, 9 ,2 <BR /> 6, 201507, 201507|201508, 11, 7 <BR /> 7, 201507, 201507|201509, 11 ,4 <BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /> </SPAN></P></BODY></HTML> Wed, 04 Feb 2015 17:58:34 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745459#M662386 2015-02-04T17:58:34Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745460#M662387 <HTML><HEAD></HEAD><BODY><P>thanks</P><P></P><P>and if the situation is this?</P><P><SPAN style="font-size: 8pt;">a:<BR /><BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /><BR /> id, DATE_FROM, DATE_FROM_DATE_TO, IN_PORTFOLIO, GO<BR /> 1, 201506, 201506|201507, 9 ,1 <BR /> 2, 201506, 201506|201508, 9 ,6 <BR /> 3, 201506, 201506|201508, 9 ,6 <BR /> 4, 201506, 201506|201508, 9 ,6 <BR /> 5, 201506, 201506|201509, 9 ,2 <BR /> 6, 201507, 201507|201508, 11, 7 <BR /> 7, 201507, 201507|201509, 11 ,4 <BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /></SPAN></P></BODY></HTML> Wed, 04 Feb 2015 17:58:53 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745460#M662387 2015-02-04T17:58:53Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745461#M662388 <HTML><HEAD></HEAD><BODY><P>No idea. You didn't say if SPECT can have negative values or that it cannot be less than zero. If it can't be less than zero try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">rangemax(0,rangesum(-GO, If(DATE_FROM=previous(DATE_FROM),peek('SPECT'),IN_PORTFOLIO))) as SPECT</SPAN></P></BODY></HTML> Wed, 04 Feb 2015 18:12:09 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745461#M662388 Gysbert_Wassenaar 2015-02-04T18:12:09Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745462#M662389 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 376px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD height="17" style="border: 0.5pt solid gainsboro; border-image: none; width: 56pt; height: 12.75pt; border-collapse: collapse; background-color: whitesmoke;" width="75"><P>ID</P></TD><TD height="17" style="border: 0.5pt solid gainsboro; border-image: none; width: 56pt; height: 12.75pt; border-collapse: collapse; background-color: whitesmoke;" width="75"><STRONG style="color: #333333; font-family: Tahoma;">DATE_FROM</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; border-image: none; width: 102pt; border-collapse: collapse; background-color: whitesmoke;" width="136"><STRONG style="color: #333333; font-family: Tahoma;">DATE_FROM_DATE_TO</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; border-image: none; width: 67pt; border-collapse: collapse; background-color: whitesmoke;" width="89"><STRONG style="color: #333333; font-family: Tahoma;">IN_PORTFOLIO</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; border-image: none; width: 17pt; border-collapse: collapse; background-color: whitesmoke;" width="23"><STRONG style="color: #333333; font-family: Tahoma;">GO</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; border-image: none; width: 40pt; border-collapse: collapse; background-color: whitesmoke;" width="53"><SPAN style="color: #333333; font-family: Tahoma;"><SPAN style="color: #575757; font-family: Arial;">SPECT</SPAN> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;">1</TD><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201507</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">1</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">8</SPAN></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;">2</TD><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201508</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">6</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2</SPAN></TD></TR><TR><TD>3</TD><TD><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD><TD><SPAN style="color: #333333; font-family: Tahoma;">201506|201508</SPAN></TD><TD>9</TD><TD>6</TD><TD>2</TD></TR><TR><TD>4</TD><TD><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD><TD><SPAN style="color: #333333; font-family: Tahoma;">201506|201508</SPAN></TD><TD>9</TD><TD>6</TD><TD>2</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;">5</TD><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201506|201509</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">9</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;">6</TD><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507|201508</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">7</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;">7</TD><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; border-image: none; height: 12.75pt; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">201507|201509</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">4</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; border-image: none; border-collapse: collapse; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">0</SPAN></TD></TR></TBODY></TABLE><P></P><P>This is the spect result for that situation...</P><P></P><P>can you please help me?</P></BODY></HTML> Thu, 05 Feb 2015 07:26:35 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745462#M662389 2015-02-05T07:26:35Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745463#M662390 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P></P><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> *, <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE_FROM_DATE_TO</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Peek</SPAN><SPAN style="font-size: 8pt;">('DATE_FROM_DATE_TO'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">PEEK</SPAN><SPAN style="font-size: 8pt;">('SPECT'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE_FROM</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Peek</SPAN><SPAN style="font-size: 8pt;">('DATE_FROM'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Peek</SPAN><SPAN style="font-size: 8pt;">('SPECT') - </SPAN><SPAN style="color: #800000; font-size: 8pt;">GO</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">IN_PORTFOLIO</SPAN><SPAN style="font-size: 8pt;"> - </SPAN><SPAN style="color: #800000; font-size: 8pt;">GO</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">SPECT</SPAN><SPAN style="font-size: 8pt;">;<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ID</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE_FROM</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE_FROM_DATE_TO</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">IN_PORTFOLIO</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">GO</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /><SPAN> [</SPAN><A class="jive-link-thread-small" data-containerid="2061" data-containertype="14" data-objectid="150786" data-objecttype="1" href="http://community.qlik.com/thread/150786">http://community.qlik.com/thread/150786</A><SPAN>]</SPAN><BR /> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">html</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">codepage</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> 1252, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">embedded</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">labels</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">table</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> @2);<BR /> </SPAN></P><P></P><P></P></BODY></HTML> Thu, 05 Feb 2015 07:40:07 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745463#M662390 MayilVahanan 2015-02-05T07:40:07Z Re: LOAD CALCULATE https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745464#M662391 <HTML><HEAD></HEAD><BODY><P>thanks <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="7234" data-externalid="" data-presence="null" data-userid="88778" data-username="MayilVahanan" href="https://community.qlik.com/people/MayilVahanan"><STRONG style="color: #3778c7;">Mayil Vahanan Ramasamy</STRONG></A>!!</P></BODY></HTML> Thu, 05 Feb 2015 07:59:21 GMT https://community.qlik.com/t5/QlikView/LOAD-CALCULATE/m-p/745464#M662391 2015-02-05T07:59:21Z