topic Error in expression:, is not a valid function Applymap Preceding Load in QlikView

Error in expression:, is not a valid function Applymap Preceding Load

Thu, 17 Mar 2016 21:33:38 GMT

Appreciate the help!!!

Error in expression:, is not a valid function

Load *,

//vlookups

IF([Status]= 'Unauthorized',Applymap ('Losses',[ID],'N/A') +Applymap ('gains',[ID],'N/A'),0) as lookup;

Load

Status

Name

Number

Applymap ('Losses',[ID],'N/A') as Losses

Applymap ('gains',[ID],'N/A') as Gains

From

Re: Error in expression:, is not a valid function Applymap Preceding Load

Chanty4u — Fri, 18 Mar 2016 10:42:00 GMT

can u share that screen sht of error msg?

Re: Error in expression:, is not a valid function Applymap Preceding Load

Anonymous — Fri, 18 Mar 2016 10:45:30 GMT

Could you share your full script?

Why you are using this?

IF([Status]= 'Unauthorized',Applymap ('Losses',[ID],'N/A') +Applymap ('gains',[ID],'N/A'),0) as lookup;

Re: Error in expression:, is not a valid function Applymap Preceding Load

Digvijay_Singh — Fri, 18 Mar 2016 10:45:47 GMT

It seems [ID] is not loaded in first load, if it is not, you cannot use in top load!

Re: Error in expression:, is not a valid function Applymap Preceding Load

sunny_talwar — Fri, 18 Mar 2016 10:48:32 GMT

May be this:

IF([Status]= 'Unauthorized',Applymap ('Losses',[ID],Dual('N/A', 0)) + Applymap ('gains',[ID], Dual('N/A', 0)),0) as lookup;

Re: Error in expression:, is not a valid function Applymap Preceding Load

Chanty4u — Fri, 18 Mar 2016 10:49:11 GMT

chk dis

Apply Map Functions - Sources

Re: Error in expression:, is not a valid function Applymap Preceding Load

jonathandienst — Fri, 18 Mar 2016 10:52:49 GMT

Digvijay is correct - the preceding load consumes the output of the following load, and ID is not part of that output, but the ApplyMaps are not required as you have them in the bottom load already.

Just use

LOAD *,

IF(Status = 'Unauthorized', Losses + Gains, 0) as lookup;

LOAD ...

Re: Error in expression:, is not a valid function Applymap Preceding Load

Fri, 18 Mar 2016 14:29:10 GMT

This was it and you saved my whole weekend!! thanks a million!!!!!!!