ApplyMap Unusual Error

[qliky88]

Hi All, 

I am experiencing an unusual issue with the ApplyMap function and was hoping someone could help/ point me in the right direction. 

I have 2 ApplyMap functions in my script funtion A and function B, A is working perfect however the other one is not returning any data and returning NA and I cannot understand why.

Function A is an applymap using strings, B is dealing with numbers mapping Lot numbers back to their corresponding lot. These lot numbers are stored in an excel file that I attach to the script (A is also coming from an excel file).

Function B -  ApplyMap('NumberLot', LotNumber, 'NA') as prodlotnum;

When prodlotnum is initially loaded into the table it comes in as Geo Data, which I then have to manually change in the table, however this does not fix the issue although I think it may be a hint as to what is going wrong with the map. 

Any tips or advice? 

Thanks 
 

[sunny_talwar]

Is it possible that one source is text and other one is number? If that is true, you will have to make sure that they are both read the same way (both read as text or number)

[Gabriel]

Hi,

What I will suggest is to try below

Function B -  ApplyMap('NumberLot', NUM(LotNumber), 'NA') as prodlotnum;

Function B -  ApplyMap('NumberLot', FLOOR(LotNumber), 'NA') as prodlotnum;

[qliky88 · Accepted solution]

Not sure what the problem was in the end, ended up creating a whole new app and just transferring everything over. Must be a rare glitch with Qlik Sense 🙂