topic Syntax error, missing/misplaced FROM in App Development

topic Syntax error, missing/misplaced FROM in App Development https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444358#M35053 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>i have a problem when I'm reloading the script , the scripte is as below. but it can be reload in my  colleqgue's computer, do you have any idea about it ?</P><P></P><P>Syntax error, missing/misplaced FROM:</P><P>SLA_RAG_September:</P><P>Join(ISL_RAG)</P><P>LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,</P><P>     [Code marché(R1)], </P><P>     [Family(R0)], </P><P>     [Family Code(R1)], </P><P>     [GMID Code(R1)] as [GMID Code], </P><P>     [Supply Chain Product Description(R0)], </P><P>     [Groupe Usine Code(R0)], </P><P>     [Groupe Usine(R0)], </P><P>     [Division Usine Majeure(R0)], </P><P>     [Statut du lien(R0)], </P><P>     [Statut du Produit(R0)], </P><P>     [Quantité Prévue(R5)], </P><P>     [Quantité Vendue], </P><P>     [Sales 3 Months / Forecasts 3 months], </P><P>     [Quantité engagement], </P><P>     [Stock Total CDIS], </P><P>     [Stock Sécu(JO)(R1)], </P><P>     [* SSV], </P><P>     [Stock Maxi(JO)(R1)], </P><P>     [Quantité Prévue(R2)], </P><P>     [* Stock Target MIN [Packs]]], </P><P>     [* Stock Target MAX [Packs]]], </P><P>     [* RAG Delay [Packs]]], </P><P>     [* Stock Mkt  ONLY], </P><P>     [Stock Total MKT], </P><P>     [Stock Transit MKT], </P><P>     [* MKT Coverage [in months]]], </P><P>     [* % of Stock Mkt missing to reach MIN Stk Target], </P><P>     [* RAG Delay [Packs]]1], </P><P>     [* SKU below MIN Target], </P><P>     [* SKU within the limits], </P><P>     [* SKU above MAX Target], </P><P>     [* RAG Excess [Packs]]], </P><P>     [* % of Stock Mkt above MAX Stock Target], </P><P>     [* % of Stock Within the TARGETS], </P><P>     [% RAG/(RAG+BAD) 3 mois(R0)],</P><P>   </P><P>ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],</P><P>     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],</P><P>     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],</P><P>     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],</P><P>     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],</P><P>     num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],</P><P>     num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],</P><P>     num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],</P><P>     num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]</P><P>From</P><P><C></C></P><P>(ooxml, embedded labels, header is 2 lines, table is [Data base$])</P><P>SLA_RAG_September:</P><P>Join(ISL_RAG)</P><P>LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,</P><P>     [Code marché(R1)], </P><P>     [Family(R0)], </P><P>     [Family Code(R1)], </P><P>     [GMID Code(R1)] as [GMID Code], </P><P>     [Supply Chain Product Description(R0)], </P><P>     [Groupe Usine Code(R0)], </P><P>     [Groupe Usine(R0)], </P><P>     [Division Usine Majeure(R0)], </P><P>     [Statut du lien(R0)], </P><P>     [Statut du Produit(R0)], </P><P>     [Quantité Prévue(R5)], </P><P>     [Quantité Vendue], </P><P>     [Sales 3 Months / Forecasts 3 months], </P><P>     [Quantité engagement], </P><P>     [Stock Total CDIS], </P><P>     [Stock Sécu(JO)(R1)], </P><P>     [* SSV], </P><P>     [Stock Maxi(JO)(R1)], </P><P>     [Quantité Prévue(R2)], </P><P>     [* Stock Target MIN [Packs]]], </P><P>     [* Stock Target MAX [Packs]]], </P><P>     [* RAG Delay [Packs]]], </P><P>     [* Stock Mkt  ONLY], </P><P>     [Stock Total MKT], </P><P>     [Stock Transit MKT], </P><P>     [* MKT Coverage [in months]]], </P><P>     [* % of Stock Mkt missing to reach MIN Stk Target], </P><P>     [* RAG Delay [Packs]]1], </P><P>     [* SKU below MIN Target], </P><P>     [* SKU within the limits], </P><P>     [* SKU above MAX Target], </P><P>     [* RAG Excess [Packs]]], </P><P>     [* % of Stock Mkt above MAX Stock Target], </P><P>     [* % of Stock Within the TARGETS], </P><P>     [% RAG/(RAG+BAD) 3 mois(R0)],</P><P>   </P><P>ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],</P><P>     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],</P><P>     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],</P><P>     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],</P><P>     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],</P><P>     num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],</P><P>     num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],</P><P>     num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],</P><P>     num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]</P><P>From</P><P><C></C></P><P>(ooxml, embedded labels, header is 2 lines, table is [Data base$])</P></BODY></HTML> Wed, 06 Sep 2017 10:04:37 GMT 2017-09-06T10:04:37Z Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444358#M35053 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>i have a problem when I'm reloading the script , the scripte is as below. but it can be reload in my  colleqgue's computer, do you have any idea about it ?</P><P></P><P>Syntax error, missing/misplaced FROM:</P><P>SLA_RAG_September:</P><P>Join(ISL_RAG)</P><P>LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,</P><P>     [Code marché(R1)], </P><P>     [Family(R0)], </P><P>     [Family Code(R1)], </P><P>     [GMID Code(R1)] as [GMID Code], </P><P>     [Supply Chain Product Description(R0)], </P><P>     [Groupe Usine Code(R0)], </P><P>     [Groupe Usine(R0)], </P><P>     [Division Usine Majeure(R0)], </P><P>     [Statut du lien(R0)], </P><P>     [Statut du Produit(R0)], </P><P>     [Quantité Prévue(R5)], </P><P>     [Quantité Vendue], </P><P>     [Sales 3 Months / Forecasts 3 months], </P><P>     [Quantité engagement], </P><P>     [Stock Total CDIS], </P><P>     [Stock Sécu(JO)(R1)], </P><P>     [* SSV], </P><P>     [Stock Maxi(JO)(R1)], </P><P>     [Quantité Prévue(R2)], </P><P>     [* Stock Target MIN [Packs]]], </P><P>     [* Stock Target MAX [Packs]]], </P><P>     [* RAG Delay [Packs]]], </P><P>     [* Stock Mkt  ONLY], </P><P>     [Stock Total MKT], </P><P>     [Stock Transit MKT], </P><P>     [* MKT Coverage [in months]]], </P><P>     [* % of Stock Mkt missing to reach MIN Stk Target], </P><P>     [* RAG Delay [Packs]]1], </P><P>     [* SKU below MIN Target], </P><P>     [* SKU within the limits], </P><P>     [* SKU above MAX Target], </P><P>     [* RAG Excess [Packs]]], </P><P>     [* % of Stock Mkt above MAX Stock Target], </P><P>     [* % of Stock Within the TARGETS], </P><P>     [% RAG/(RAG+BAD) 3 mois(R0)],</P><P>   </P><P>ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],</P><P>     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],</P><P>     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],</P><P>     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],</P><P>     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],</P><P>     num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],</P><P>     num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],</P><P>     num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],</P><P>     num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]</P><P>From</P><P><C></C></P><P>(ooxml, embedded labels, header is 2 lines, table is [Data base$])</P><P>SLA_RAG_September:</P><P>Join(ISL_RAG)</P><P>LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,</P><P>     [Code marché(R1)], </P><P>     [Family(R0)], </P><P>     [Family Code(R1)], </P><P>     [GMID Code(R1)] as [GMID Code], </P><P>     [Supply Chain Product Description(R0)], </P><P>     [Groupe Usine Code(R0)], </P><P>     [Groupe Usine(R0)], </P><P>     [Division Usine Majeure(R0)], </P><P>     [Statut du lien(R0)], </P><P>     [Statut du Produit(R0)], </P><P>     [Quantité Prévue(R5)], </P><P>     [Quantité Vendue], </P><P>     [Sales 3 Months / Forecasts 3 months], </P><P>     [Quantité engagement], </P><P>     [Stock Total CDIS], </P><P>     [Stock Sécu(JO)(R1)], </P><P>     [* SSV], </P><P>     [Stock Maxi(JO)(R1)], </P><P>     [Quantité Prévue(R2)], </P><P>     [* Stock Target MIN [Packs]]], </P><P>     [* Stock Target MAX [Packs]]], </P><P>     [* RAG Delay [Packs]]], </P><P>     [* Stock Mkt  ONLY], </P><P>     [Stock Total MKT], </P><P>     [Stock Transit MKT], </P><P>     [* MKT Coverage [in months]]], </P><P>     [* % of Stock Mkt missing to reach MIN Stk Target], </P><P>     [* RAG Delay [Packs]]1], </P><P>     [* SKU below MIN Target], </P><P>     [* SKU within the limits], </P><P>     [* SKU above MAX Target], </P><P>     [* RAG Excess [Packs]]], </P><P>     [* % of Stock Mkt above MAX Stock Target], </P><P>     [* % of Stock Within the TARGETS], </P><P>     [% RAG/(RAG+BAD) 3 mois(R0)],</P><P>   </P><P>ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],</P><P>     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],</P><P>     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],</P><P>     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],</P><P>     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],</P><P>     num(if(Isnull([* Stock Mkt  ONLY]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[* Stock Mkt  ONLY])),'0,00') as [stock market only valued in €],</P><P>     num(if(IsNull([Quantité Prévue(R2)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R2)])),'0,0') as [3 next month forecast sales in €],</P><P>     num(if(isnull([Quantité Prévue(R5)]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Prévue(R5)])),'0,0') as [Forecast last 3 months in €],</P><P>     num(if(isnull([Quantité Vendue]),0,(Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*[Quantité Vendue])),'0,0') as [Sales last 3 months in €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],</P><P>     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]</P><P>From</P><P><C></C></P><P>(ooxml, embedded labels, header is 2 lines, table is [Data base$])</P></BODY></HTML> Wed, 06 Sep 2017 10:04:37 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444358#M35053 2017-09-06T10:04:37Z Re: Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444359#M35054 <HTML><HEAD></HEAD><BODY><P>There are at least the semi-colons missing - after the load-statements:</P><P></P><P>...</P><TABLE><TBODY><TR><TD></TD><TD>num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]</TD></TR></TBODY></TABLE><P>From</P><P><C></C></P><P>(ooxml, embedded labels, header is 2 lines, table is [Data base$])<STRONG style=": ; color: #ff0000; font-size: 12pt;">;</STRONG></P><P>SLA_RAG_September:</P><P>Join(ISL_RAG)</P><P>...</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 07 Sep 2017 10:50:14 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444359#M35054 marcus_sommer 2017-09-07T10:50:14Z Re: Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444360#M35055 <HTML><HEAD></HEAD><BODY><P><STRONG><C>  -- this will work in qlik sense if legacy mode is on(Check whether Legacy mode is on. Else Create an Folder connection and use  [Lib://Connection Name/SLA Compliance.xls])</C></STRONG></P><P></P><P>Also ; is missing at the end of the statement.</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 07 Sep 2017 11:21:43 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444360#M35055 shraddha_g 2017-09-07T11:21:43Z Re: Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444361#M35056 <HTML><HEAD></HEAD><BODY><P>Thanks a lot , the problem is solved .<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 08 Sep 2017 07:03:44 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444361#M35056 2017-09-08T07:03:44Z Re: Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444362#M35057 <HTML><HEAD></HEAD><BODY><P>Thank you very much , it's working for me.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Fri, 08 Sep 2017 07:04:47 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444362#M35057 2017-09-08T07:04:47Z Re: Syntax error, missing/misplaced FROM https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444363#M35058 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Fri, 08 Sep 2017 07:34:30 GMT https://community.qlik.com/t5/App-Development/Syntax-error-missing-misplaced-FROM/m-p/1444363#M35058 oknotsen 2017-09-08T07:34:30Z