I have a look up table with county names. I even have names spelled multiple ways in case users override the controls (not under my area) and type the in all caps or the correct way.
The problem is I have a table which I want to count the number of records by county which seems simple but if there are counties not found in my look up table then I get a - in the county name field which I can't select on. The beauty of Qlik is that you can click on a field like county 'XYZ' and all the other data reflects just that county. I want to be able to show the Misspelled counties as well so the users can work with whoever is inputting to do data cleanup. Thanks.
If you are using Applymap() it has a default value parameter which is return value incase the lookup value does not exist in mapping table
example
Applymap(YouMappingTable, MappingValue , MappingValue ) << in this case it will return the same field value if the mapping value does not exist in mapping table
