topic applymap? in QlikView https://community.qlik.com/t5/QlikView/applymap/m-p/799581#M1039993 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>how it works</P><P></P><P>applymap('item',product,'100%')</P><P></P><P>what is 100% here&nbsp; i know that not matching values will go there&nbsp; is in't or anything is there?</P></BODY></HTML> Tue, 09 Dec 2014 08:10:28 GMT Anonymous 2014-12-09T08:10:28Z applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/799581#M1039993 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>how it works</P><P></P><P>applymap('item',product,'100%')</P><P></P><P>what is 100% here&nbsp; i know that not matching values will go there&nbsp; is in't or anything is there?</P></BODY></HTML> Tue, 09 Dec 2014 08:10:28 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/799581#M1039993 Anonymous 2014-12-09T08:10:28Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/799582#M1039994 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes right when no value match 100% is fill there.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 09 Dec 2014 08:15:04 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/799582#M1039994 its_anandrjs 2014-12-09T08:15:04Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/799583#M1039995 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">This 3rd parameter can be anything whatever you want to insert dummy value if condition is not matching</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">It works just like VLOOKUP in Excel but the lookup table must only contain 2 columns</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">see this also</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A class="jive-link-external-small" href="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/</A></P></BODY></HTML> Tue, 09 Dec 2014 08:15:50 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/799583#M1039995 Anonymous 2014-12-09T08:15:50Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/799584#M1039996 <HTML><HEAD></HEAD><BODY><P><A name="kanchor833"></A><A name="applymap"></A><SPAN class="Bold">applymap(</SPAN><SPAN class="Italic">'mapname', expr [ , defaultexpr ] </SPAN><SPAN class="Bold">)</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold">the third value in your case '100%' which is optional is the default value if the applymap did not match.<BR /></SPAN></P></BODY></HTML> Tue, 09 Dec 2014 08:17:42 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/799584#M1039996 maleksafa 2014-12-09T08:17:42Z