After upgrading QlikView to 12.20 version the ApplyMap() stops working as it was in the past version, throwing an incorrect mapping. The different behavior is due to an intentional change from R&D for QlikView Version 12. In the old version ApplyMap was less restrictive, but also very open to errors and bugs in the script triggering different errors that were not caught or visible.
- QlikView 12.00 and 12.10
QlikView 12.20 (November 2017) and up
The different behavior is due to an intentional change from R&D for QlikView Version 12 and up.
In QlikView version 12 the new functionality is just to execute in the way that is currently stated in the documentation, where basically says that all mapping statements now require a well-established static table name.
From documentation:
"The name of a mapping table that has previously been created through the mapping load or the mapping select statement. Its name must be enclosed by single, straight quotation marks."Other recommendations:
- To be cautious when trying to map numerical values with certain unhandled precision since the ApplyMap() function is intended only for text values or numerical with a defined numerical format.
- The Mapping load using optimized QVD's is an unsupported scenario try to avoid use this see the next community article for further reference: https://community.qlik.com/docs/DOC-1292