It's possibly a mismatch between the keys, like one value has leading/trailing blanks and the other does not. My approach to debugging this is to remove the mapping prefix to create a regular table and examine both sets of values in the Data Model Viewer or the UI.
it looks like you don’t have the correct mapping table name in the applymap. I actually don’t know what # does to a Qlik table name, so I would just name the first mapping table as Mapping_Table. Then in the apply map your first parameter should match the mapping table name ‘Mapping_Table’ including the single quotes.
sorry...that was a careless typo......but other than that, everything looks ok ,right ...should return me Yes if the value at Fact table matches the key at Mapping_Table ...otherwise, no right? but all I get is No....
It's possibly a mismatch between the keys, like one value has leading/trailing blanks and the other does not. My approach to debugging this is to remove the mapping prefix to create a regular table and examine both sets of values in the Data Model Viewer or the UI.
