Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

define default value in applymap/mapping load

Hi all,

I am trying to do something like this.

MapCustomerTable:

Mapping Load

KeyField,

CustName

from Customer.xls;

TransactionTable:

Load

KeyField1,

Applymap('MapCustomerTable',KeyField) as CustName

from.....;

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.

Tags (2)
1 Solution

Accepted Solutions
salto
Valued Contributor II

Re: define default value in applymap/mapping load

Hello,

try with

applymap('MapCustomerTable',KeyField,'DefaultValue') as CustName

Hope this helps!

2 Replies
salto
Valued Contributor II

Re: define default value in applymap/mapping load

Hello,

try with

applymap('MapCustomerTable',KeyField,'DefaultValue') as CustName

Hope this helps!

Not applicable

Re: define default value in applymap/mapping load

Thanks

Community Browser