Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

radupanciuc
New Contributor II

Field not Found

Hi guys,

i am creating a new filed called Survey? (in the script editor) based on the following condition:

if( A > B, 'Survey', 'No Survey') as [Survey?],


The problem is that field B is not in the source data but I am mapping it using MAPPING LOAD/APPLYMAP.


Sense gives me the error that Field B cannot be found.


Is there a solution to this?


1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Field not Found

try

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

    if("Amount" >ApplyMap('SurveryLimit',"Claim To Code",'#N/A'), 'Survey', 'No Survey') as [Survey?]

   

FROM [Table.xlsx];

8 Replies
agigliotti
Honored Contributor II

Re: Field not Found

please post the entire script to help you.

prma7799
Honored Contributor III

Re: Field not Found

Please share your script ...

shraddha_g
Honored Contributor III

Re: Field not Found

Share a screenshot of your script

radupanciuc
New Contributor II

Re: Field not Found

This is the current script:

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

           

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

   

  

    if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?],

   

FROM [Table.xlsx];

shraddha_g
Honored Contributor III

Re: Field not Found

try

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

    if("Amount" >ApplyMap('SurveryLimit',"Claim To Code",'#N/A'), 'Survey', 'No Survey') as [Survey?]

   

FROM [Table.xlsx];

shraddha_g
Honored Contributor III

Re: Field not Found

also check whether applymap is giving any value in return

agigliotti
Honored Contributor II

Re: Field not Found

try with the below script:

LOAD *,

if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?];

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",  

          

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount

  

FROM [Table.xlsx];

sumanta12
Contributor II

Re: Field not Found

Try using the below script:

TAB1:

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",  

          

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount

  

FROM [Table.xlsx];

TAB2:

LOAD

if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?],

"Survey Limit ($)",  

Region,

    Subs,

   "Claim No.",

   "Claim To Code",

    Amount

   

RESIDENT TAB1;

DROP TABLE TAB1;