topic Help Needed in QlikView https://community.qlik.com/t5/QlikView/Help-Needed/m-p/430471#M160496 <HTML><HEAD></HEAD><BODY><DIV>Hi All, </DIV><DIV> Struck up with the following issue and need your help.&nbsp; </DIV><DIV> </DIV><DIV> </DIV><DIV><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 110px;"><TBODY><TR><TD class="xl63" height="17" width="110">TermStartDate</TD></TR>The Terrm Start Date have the&nbsp;&nbsp; following values.&nbsp; <TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/01/2010</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/05/2012</TD></TR></TBODY><TBODY></TBODY><TBODY></TBODY><TBODY><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/01/2013</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>I am using the following code to get the TermStartDate Values into my Table . </DIV><DIV> </DIV><DIV><DIV>TermStart:</DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">Mapping</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">Key</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">TermStartDate</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Resident</SPAN><SPAN style="font-size: 8pt;"> TempTable; </SPAN></DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Load </SPAN></DIV><DIV><SPAN style="font-size: 8pt;">Key,</SPAN></DIV><DIV>Applymap</DIV><DIV><SPAN style="font-size: 8pt;">('TermStart',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Key</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</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;">TermStartDate</SPAN><SPAN style="font-size: 8pt;">, </SPAN></DIV><DIV>Country,</DIV><DIV>Status</DIV><DIV>from Employee.Qvd;</DIV><DIV> </DIV><DIV>But I am getting only one value . How could I resolve this problem.&nbsp; </DIV><DIV> </DIV><DIV><TABLE border="0" cellpadding="0" cellspacing="0" height="160" style="width: 89px; height: 28px;"><TBODY><TR><BR /><TD class="xl63" height="17" width="110">TermStartDate</TD></TR><TR><BR /><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/05/2012</TD><BR /> </TR></TBODY></TABLE></DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Regards,</SPAN></DIV><DIV><SPAN style="font-size: 8pt;">Alvin.</SPAN></DIV><DIV> </DIV><DIV> </DIV></DIV></BODY></HTML> Wed, 12 Dec 2012 14:51:11 GMT alvinford 2012-12-12T14:51:11Z Help Needed https://community.qlik.com/t5/QlikView/Help-Needed/m-p/430471#M160496 <HTML><HEAD></HEAD><BODY><DIV>Hi All, </DIV><DIV> Struck up with the following issue and need your help.&nbsp; </DIV><DIV> </DIV><DIV> </DIV><DIV><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 110px;"><TBODY><TR><TD class="xl63" height="17" width="110">TermStartDate</TD></TR>The Terrm Start Date have the&nbsp;&nbsp; following values.&nbsp; <TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/01/2010</TD></TR><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/05/2012</TD></TR></TBODY><TBODY></TBODY><TBODY></TBODY><TBODY><TR><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/01/2013</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>I am using the following code to get the TermStartDate Values into my Table . </DIV><DIV> </DIV><DIV><DIV>TermStart:</DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">Mapping</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>Load</STRONG></SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">Key</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">TermStartDate</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Resident</SPAN><SPAN style="font-size: 8pt;"> TempTable; </SPAN></DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Load </SPAN></DIV><DIV><SPAN style="font-size: 8pt;">Key,</SPAN></DIV><DIV>Applymap</DIV><DIV><SPAN style="font-size: 8pt;">('TermStart',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Key</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</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;">TermStartDate</SPAN><SPAN style="font-size: 8pt;">, </SPAN></DIV><DIV>Country,</DIV><DIV>Status</DIV><DIV>from Employee.Qvd;</DIV><DIV> </DIV><DIV>But I am getting only one value . How could I resolve this problem.&nbsp; </DIV><DIV> </DIV><DIV><TABLE border="0" cellpadding="0" cellspacing="0" height="160" style="width: 89px; height: 28px;"><TBODY><TR><BR /><TD class="xl63" height="17" width="110">TermStartDate</TD></TR><TR><BR /><TD class="xl64" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">01/05/2012</TD><BR /> </TR></TBODY></TABLE></DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Regards,</SPAN></DIV><DIV><SPAN style="font-size: 8pt;">Alvin.</SPAN></DIV><DIV> </DIV><DIV> </DIV></DIV></BODY></HTML> Wed, 12 Dec 2012 14:51:11 GMT https://community.qlik.com/t5/QlikView/Help-Needed/m-p/430471#M160496 alvinford 2012-12-12T14:51:11Z Re: Help Needed https://community.qlik.com/t5/QlikView/Help-Needed/m-p/430472#M160497 <HTML><HEAD></HEAD><BODY><P>Please don't double-post. This post is a repeat of <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/290809#290809">http://community.qlik.com/message/290809#290809</A></P></BODY></HTML> Wed, 12 Dec 2012 15:54:23 GMT https://community.qlik.com/t5/QlikView/Help-Needed/m-p/430472#M160497 vgutkovsky 2012-12-12T15:54:23Z