topic Re: applymap in QlikView https://community.qlik.com/t5/QlikView/applymap/m-p/285037#M712548 <HTML><HEAD></HEAD><BODY><P>Hi, Annika.</P><P>Have a look at Steve Dark's blog. It may help.</P><P></P><P><A href="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/" title="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/">http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/</A></P><P></P><P>Regards,</P><P>Neil</P></BODY></HTML> Fri, 13 Sep 2013 08:59:10 GMT ngulliver 2013-09-13T08:59:10Z applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285033#M712544 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P>I want to know if there's in some cases where you shouldn't use applymap. I have a datamodel where there's a few dimensions that only consists of two field. So my plan is to integrate them with the fact table. </P><P></P><P>Or can i screw things up doing that in some cases? </P><P></P><P>Thanks! </P></BODY></HTML> Tue, 14 Jun 2011 06:49:41 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285033#M712544 Anonymous 2011-06-14T06:49:41Z applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285034#M712545 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I don't see any problem using ApplyMap other than a JOIN may perform better if your volume of data is high. Note that ApplyMap only allows two fields, and depending on your datamodel, this may not be enough or it may require to nest applymaps, and it may make the load slower...</P><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Tue, 14 Jun 2011 08:10:06 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285034#M712545 Miguel_Angel_Baeyens 2011-06-14T08:10:06Z Re: applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285035#M712546 <HTML><HEAD></HEAD><BODY><P>t</P></BODY></HTML> Thu, 05 Sep 2013 19:33:00 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285035#M712546 2013-09-05T19:33:00Z Re: applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285036#M712547 <HTML><HEAD></HEAD><BODY><P>Apply maps only work for a 1 to 1 join as well.&nbsp; So if the key can have multiple values you'd need to use a join.</P></BODY></HTML> Thu, 05 Sep 2013 19:35:43 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285036#M712547 jpapador 2013-09-05T19:35:43Z Re: applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285037#M712548 <HTML><HEAD></HEAD><BODY><P>Hi, Annika.</P><P>Have a look at Steve Dark's blog. It may help.</P><P></P><P><A href="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/" title="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/">http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/</A></P><P></P><P>Regards,</P><P>Neil</P></BODY></HTML> Fri, 13 Sep 2013 08:59:10 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285037#M712548 ngulliver 2013-09-13T08:59:10Z Re: applymap https://community.qlik.com/t5/QlikView/applymap/m-p/285038#M712549 <HTML><HEAD></HEAD><BODY><P>it based on primary key. so whenever you&nbsp; don't have a primary key you are not able to use applymap</P><P></P><P></P><P></P><P></P><P>Regards</P></BODY></HTML> Fri, 13 Sep 2013 09:39:25 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/285038#M712549 techvarun 2013-09-13T09:39:25Z