topic Re: Substitute values in QlikView

Substitute values

Wed, 29 Apr 2015 18:06:39 GMT

Hi,

I have a field called Inactive_Contact__c where the values are true or false.

eComContacts:

LOAD Id as ContactId,

AccountId,

Inactive_Contact__c,

Business__c,

Name;

SQL SELECT *

FROM Contact

WHERE AccountId != NULL;

How do I convert all the true values to YES and all the false values to null or -?

Re: Substitute values

ramoncova06 — Wed, 29 Apr 2015 18:10:44 GMT

you can use an if statement

eComContacts:

LOAD Id as ContactId,

AccountId,

if(Inactive_Contact__c = 'True','YES', null()) as Inactive_Contact__c ,

Business__c,

Name;

SQL SELECT *

FROM Contact

WHERE AccountId != NULL;

another option is to use wildmatch

Re: Substitute values

Wed, 29 Apr 2015 18:25:30 GMT

thanks ramon