https://community.qlik.com/t5/App-Development/Limitation-of-Apply-Map-and-Mapping-Load/m-p/1769658#M59516 <P>I am trying to do currency conversion in a table. Where we have maintained two tables one for exchange rate and one in which foreign currency is there. Now the problem that we are facing is that only on some dates apply map is being applied for rest it is not being applied. Is this some limitation of apply map. Data size is large.</P> Sat, 16 Nov 2024 17:41:13 GMT Sanket_Sharma 2024-11-16T17:41:13Z https://community.qlik.com/t5/App-Development/Limitation-of-Apply-Map-and-Mapping-Load/m-p/1769658#M59516 <P>I am trying to do currency conversion in a table. Where we have maintained two tables one for exchange rate and one in which foreign currency is there. Now the problem that we are facing is that only on some dates apply map is being applied for rest it is not being applied. Is this some limitation of apply map. Data size is large.</P> Sat, 16 Nov 2024 17:41:13 GMT https://community.qlik.com/t5/App-Development/Limitation-of-Apply-Map-and-Mapping-Load/m-p/1769658#M59516 Sanket_Sharma 2024-11-16T17:41:13Z https://community.qlik.com/t5/App-Development/Limitation-of-Apply-Map-and-Mapping-Load/m-p/1769660#M59517 <P>My best guess is that your numeric values in the map key does not match.</P><P>Date (today())&nbsp; is not equal to Date(now()) even if their would look the same in the user interface. The numeric value of date(today()) is an integer, but fo| date(now()) it is a decimal containing hidden info about time of day.&nbsp;</P><P>Try to wrap dayname() around the lookup value in both transaction and map table to eliminate this problem.&nbsp;</P> Sun, 20 Dec 2020 07:24:03 GMT https://community.qlik.com/t5/App-Development/Limitation-of-Apply-Map-and-Mapping-Load/m-p/1769660#M59517 Vegar 2020-12-20T07:24:03Z