topic Re: Apllymap function not working well in QlikView https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385461#M1155578 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>Thanks a lot...</P><P></P><P>Regards,</P><P>Senthil..</P></BODY></HTML> Wed, 27 Feb 2013 03:10:58 GMT 2013-02-27T03:10:58Z Apllymap function not working well https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385459#M1155572 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi All,</SPAN></P><P></P><P><SPAN style="color: #000000;"> In Applymap function can I use more than two parameter values,</SPAN></P><P><SPAN style="color: #000000;"> Please find below statement,</SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: #000000;"><SPAN style="font-size: 9pt; font-family: 'Courier New';">ApplyMap:<BR /> </SPAN><STRONG><SPAN style="font-size: 9pt; font-family: 'Courier New';">Mapping</SPAN> </STRONG><SPAN style="font-size: 9pt; font-family: 'Courier New';">load</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"> * </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">Inline</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"><BR /> </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">[<BR /> Grade,Score<BR /> A,1<BR /> B,2<BR /> C,3<BR /> D,4<BR /> ]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">;<BR /> <BR /> UsingApplyMap:<BR /> </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">LOAD</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"> * </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">Inline</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"><BR /> </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">[<BR /> Emp_Name,Salary,Loc<BR /> A,1000,Chennai<BR /> B,2000,Bangalore<BR /> C,1000,Bangalore<BR /> D,1000,Bangalore<BR /> E,2000,Bangalore&nbsp;&nbsp;&nbsp; /* Not available in ApplyMap table<BR /> ]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">;<BR /> <BR /></SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">load</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">ApplyMap</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">('ApplyMap',</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">Emp_Name</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">,'unassign') </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">as</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">Emp_Grade</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">Resident</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"> UsingApplyMap; </SPAN></SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: #000000;">Above statement working fine,</SPAN></P><P></P><P><SPAN style="color: #000000;">But i am looking like,</SPAN></P><P><SPAN style="color: #000000;"><SPAN style="font-size: 9pt; font-family: 'Courier New';">load</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">ApplyMap</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">('ApplyMap',</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">Emp_Name</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">,<STRONG>’assign,'unassign'</STRONG>) </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">as</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">Emp_Grade</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New';">Resident</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';"> UsingApplyMap;</SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 9pt; font-family: 'Courier New';"><BR /></SPAN></P><P>Output like,</P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; width: 148px;"><TBODY><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid gainsboro 1.0pt; border-bottom: none; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="148"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8pt; font-family: Tahoma, sans-serif;">assign</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid gainsboro 1.0pt; border-bottom: none; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="148"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8pt; font-family: Tahoma, sans-serif;">assign</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid gainsboro 1.0pt; border-bottom: none; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="148"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8pt; font-family: Tahoma, sans-serif;">assign</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid gainsboro 1.0pt; border-bottom: none; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="148"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8pt; font-family: Tahoma, sans-serif;">unassign</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Thanks &amp; Regards,</P><P>Senthil…</P></BODY></HTML> Tue, 26 Feb 2013 18:38:02 GMT https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385459#M1155572 2013-02-26T18:38:02Z Re: Apllymap function not working well https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385460#M1155574 <HTML><HEAD></HEAD><BODY><P>Maybe just use a map that has a constant second field value: 'assign', </P><P></P><P><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';">ApplyMap:<BR /></SPAN><STRONG style="background-color: #ffffff; color: #000000; font-family: Arial;"><SPAN style="font-size: 9pt; font-family: 'Courier New';">Mapping</SPAN> </STRONG><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';">load</SPAN><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';"> Grade, 'assign' as FieldB </SPAN><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';">Inline</SPAN><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';"><BR /></SPAN><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';">[<BR />Grade<BR />A<BR />B<BR />C<BR />D<BR />]</SPAN><SPAN style="background-color: #ffffff; font-size: 9pt; color: #000000; font-family: 'Courier New';">;</SPAN></P></BODY></HTML> Tue, 26 Feb 2013 21:47:42 GMT https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385460#M1155574 swuehl 2013-02-26T21:47:42Z Re: Apllymap function not working well https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385461#M1155578 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>Thanks a lot...</P><P></P><P>Regards,</P><P>Senthil..</P></BODY></HTML> Wed, 27 Feb 2013 03:10:58 GMT https://community.qlik.com/t5/QlikView/Apllymap-function-not-working-well/m-p/385461#M1155578 2013-02-27T03:10:58Z