Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload cannot identify the field

ResultsFinal:

LOAD

OrderLine#,

Results.Customer as Final.Customer,

Results.DataSKU as Final.DataSKU,

ApplyMap('PRO_Mapping',Results.DataSKU,'NO MATCH') as Final.PRO,   //NEW ADDITION

Results.QtyUnAll as Final.QtyUnAll,

Results.DateRequest as Final.DateRequest,

Results.LWHS as Final.LWHS,

Results.OrderCategory as Final.OrderCategory,

Results.Channel as Final.Channel,

Results.BU as Final.BU,

Results.Class as Final.Class,

if(Results.DateShip-Results.DateRequest<=0,'on time',

if(Results.DateShip-Results.DateRequest<=1 and wildmatch(CUSTSHIPTO, '30070-4' , '30070-43', '30070-63' , '30070-73' , '30070-163' , '30070-263' , '30071-4' , '30071-63' , '30072-4' , '30072-63' , '30073-4' , '30073-63' , '30074-4' ,'30074-13' , '30074-313' , '30070-3' , '30070-4' )>0, 'on time',

if(Results.DateShip-Results.DateRequest<=2 and wildmatch(CUSTSHIPTO, '30070-4' , '30070-43', '30070-63' , '30070-73' , '30070-163' , '30070-263' , '30071-4' , '30071-63' , '30072-4' , '30072-63' , '30073-4' , '30073-63' , '30074-4' ,'30074-13' , '30074-313' , '30070-3' , '30070-4' )>0 , 'plus 1',

if(Results.DateShip-Results.DateRequest=1,'plus 1','delayed')))) as Final.DelayClusterSHP,

ResultsFinal:

2 Replies
MVP & Luminary
MVP & Luminary

Can you post more information. The code you posted isn't complete.


talk is cheap, supply exceeds demand
Specialist
Specialist

Hi, could you please attached some sample data or be a little bit more specific on your problem?.

So far I understand that your field CUSTSHIPTO is not recognized. This could be for a lot of reasons, from misspelling to the field not included on the data source.


Best regards,

Andrés