topic Re: Question on If(Exists(fieldname)... in QlikView

Question on If(Exists(fieldname)...

peterkumar — Wed, 25 Nov 2020 16:16:04 GMT

Hello - I am new to QlikView and will greatly appreciate guidance on the following -

In the code below, field [WCPA Actuals] takes on different values depending on whether field Eligible Key is in the WCPAlist of Eligible Keys.

How do i make it happen in the FinalData load?

WCPAlist:

Noconcatenate

Load

[Eligible Key]

From CasMap where Coverage = ‘WCPA’;

FinalData:

Noconcatenate

Load

[Eligible Key],

[Account Name],

[Create Date],

[Modified Date],

If(Exists([Eligible Key], ’WCPA’ ,’N/A’) as [WCPA Actuals]

Resident MasterTable;

WILL IF(EXISTS([Eligible Key] above WORK?

Many thanks!

Re: Question on If(Exists(fieldname)...

sunny_talwar — Mon, 09 Jan 2017 02:19:41 GMT

Try like this:

WCPAlist:

NoConcatenate

LOAD [Eligible Key] as CheckKey

From CasMap

Where Coverage = ‘WCPA’;

FinalData:

NoConcatenate

LOAD [Eligible Key],

[Account Name],

[Create Date],

[Modified Date],

If(Exists(CheckKey, [Eligible Key]), ’WCPA’ ,’N/A’) as [WCPA Actuals]

Resident MasterTable;

Re: Question on If(Exists(fieldname)...

peterkumar — Mon, 09 Jan 2017 16:51:05 GMT

Thanks Sunny. For some reason that is not working. Error I get is -

Field not found - <’WCPA’>
FinalData:
NoConcatenate

LOAD [Eligible Key],
     [Company Number],
     Source,
     [Account Name],
     Coverage,
     [Forecast Effective Date],
     [Create Date],
     [Modified Date],
     [Selected Loss Pick],

     If(Exists(CheckKey,[Eligible Key]),’WCPA’,’N/A’) as [WCPA Actual],

     [WCPA Create Date]
FROM

(txt, utf8, embedded labels, delimiter is ',', msq)

Re: Question on If(Exists(fieldname)...

sunny_talwar — Mon, 09 Jan 2017 17:15:29 GMT

I think there it is a single quote issue

If(Exists(CheckKey,[Eligible Key]),’WCPA’,’N/A’) as [WCPA Actual]

Try this:

If(Exists(CheckKey,[Eligible Key]),'WCPA',’N/A’) as [WCPA Actual]

Re: Question on If(Exists(fieldname)...

peterkumar — Mon, 09 Jan 2017 18:41:33 GMT

Many thanks Sunny!

Much appreciated.