topic Re: Code Mismatch should be displayed as Undefined in QlikView

Code Mismatch should be displayed as Undefined

Thu, 13 Aug 2015 12:44:15 GMT

HI All,

I have a scenario where my data is something like below.

Code Element

43-AB 43-AB-ASD

54-AB 54-AB-CDF

And another table where data is like below

Element

Loan Details

Payment Details

I need to categorize the above values as Undefined in Code.

If i select Undefined in code then it should display element as

Loan Details

Payment Details

Please help me with this.

Regards,

Keerthi KS

vikasmahajan — Thu, 13 Aug 2015 13:00:00 GMT

In load statement you can add following script

if( code = 0,1,if(ISNULL(code) OR LEN( code)=0,1,0)) AS Undefined,

and filter the same

HTH

Vikas

Thu, 13 Aug 2015 13:07:51 GMT

Hi,

Try like below,

Load

if(wildmatch(Element,'Loan Details','Payment Details'),'Undefined',Code) as Code,