Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to do something like this.
Applymap('MapCustomerTable',KeyField) as CustName
I am getting the right output in some place. But when Keyfield1 is not matching to KeyField, It returns the KeyField1 Instead of null or a CustName.
How can I set default value if some of the key field of main table do not match the key field of Mapping table.
Go to Solution.
applymap('MapCustomerTable',KeyField,'DefaultValue') as CustName
Hope this helps!