topic Re: Force the &quot;no answer &quot; with an applymap function in QlikView https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335345#M123655 <HTML><HEAD></HEAD><BODY><P>Yes,</P><P></P><P><EM><SPAN class="Bold">applymap(</SPAN><SPAN class="Italic">'mapname', expr [ , defaultexpr ] </SPAN><SPAN class="Bold">)</SPAN></EM></P><P class="syntax"><SPAN class="Bold"><BR /></SPAN></P><P>Just add a default value after X:</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">applymap('applymaptest', X, Z)</SPAN></P></BODY></HTML> Thu, 05 Jul 2012 08:08:04 GMT Anonymous 2012-07-05T08:08:04Z Force the "no answer " with an applymap function https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335344#M123654 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Just a question on applymap functionnality :</P><P></P><P>When you do </P><P></P><P>applymaptest:</P><P>MAPPING LOAD</P><P>X</P><P>Y</P><P>SQL SELECT X Y.....</P><P></P><P>applymap('applymaptest', X)</P><P>when applymap does not suceed in finding X, the function give you the answer X.</P><P></P><P>My question is, can we force the no answer by giving to the no answer by default Z as no answer instaed of X ?</P><P></P><P>Thanks a lot</P><P></P><P>Alex</P></BODY></HTML> Thu, 05 Jul 2012 08:05:02 GMT https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335344#M123654 alex59800 2012-07-05T08:05:02Z Re: Force the "no answer " with an applymap function https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335345#M123655 <HTML><HEAD></HEAD><BODY><P>Yes,</P><P></P><P><EM><SPAN class="Bold">applymap(</SPAN><SPAN class="Italic">'mapname', expr [ , defaultexpr ] </SPAN><SPAN class="Bold">)</SPAN></EM></P><P class="syntax"><SPAN class="Bold"><BR /></SPAN></P><P>Just add a default value after X:</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">applymap('applymaptest', X, Z)</SPAN></P></BODY></HTML> Thu, 05 Jul 2012 08:08:04 GMT https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335345#M123655 Anonymous 2012-07-05T08:08:04Z Re: Force the "no answer " with an applymap function https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335346#M123656 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Johannes, you're the one !</P><P><BR />Best regards</P></BODY></HTML> Thu, 05 Jul 2012 08:51:17 GMT https://community.qlik.com/t5/QlikView/Force-the-quot-no-answer-quot-with-an-applymap-function/m-p/335346#M123656 alex59800 2012-07-05T08:51:17Z