Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Partner
Partner

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];

View solution in original post

8 Replies
Highlighted
Partner
Partner

please post the entire script to help you.

Highlighted
Master III
Master III

Please share your script ...

Highlighted
Partner
Partner

Share a screenshot of your script

Highlighted
Contributor II
Contributor II

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];

Highlighted
Partner
Partner

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];

View solution in original post

Highlighted
Partner
Partner

also check whether applymap is giving any value in return

Highlighted
Partner
Partner

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];

Highlighted
Creator II
Creator II

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;