Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Syntax error, missing/misplaced FROM

Hello all,

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 ?

Syntax error, missing/misplaced FROM:

SLA_RAG_September:

Join(ISL_RAG)

LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,

     [Code marché(R1)],

     [Family(R0)],

     [Family Code(R1)],

     [GMID Code(R1)] as [GMID Code],

     [Supply Chain Product Description(R0)],

     [Groupe Usine Code(R0)],

     [Groupe Usine(R0)],

     [Division Usine Majeure(R0)],

     [Statut du lien(R0)],

     [Statut du Produit(R0)],

     [Quantité Prévue(R5)],

     [Quantité Vendue],

     [Sales 3 Months / Forecasts 3 months],

     [Quantité engagement],

     [Stock Total CDIS],

     [Stock Sécu(JO)(R1)],

     [* SSV],

     [Stock Maxi(JO)(R1)],

     [Quantité Prévue(R2)],

     [* Stock Target MIN [Packs]]],

     [* Stock Target MAX [Packs]]],

     [* RAG Delay [Packs]]],

     [* Stock Mkt  ONLY],

     [Stock Total MKT],

     [Stock Transit MKT],

     [* MKT Coverage [in months]]],

     [* % of Stock Mkt missing to reach MIN Stk Target],

     [* RAG Delay [Packs]]1],

     [* SKU below MIN Target],

     [* SKU within the limits],

     [* SKU above MAX Target],

     [* RAG Excess [Packs]]],

     [* % of Stock Mkt above MAX Stock Target],

     [* % of Stock Within the TARGETS],

     [% RAG/(RAG+BAD) 3 mois(R0)],

  

ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],

     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],

     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],

     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],

     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],

     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 €],

     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 €],

     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 €],

     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 €],

     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],

     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]

From

(ooxml, embedded labels, header is 2 lines, table is [Data base$])

SLA_RAG_September:

Join(ISL_RAG)

LOAD Date(Num#(F1,'DD/MM/YYYY'),'DD/MM/YYYY')as Date,

     [Code marché(R1)],

     [Family(R0)],

     [Family Code(R1)],

     [GMID Code(R1)] as [GMID Code],

     [Supply Chain Product Description(R0)],

     [Groupe Usine Code(R0)],

     [Groupe Usine(R0)],

     [Division Usine Majeure(R0)],

     [Statut du lien(R0)],

     [Statut du Produit(R0)],

     [Quantité Prévue(R5)],

     [Quantité Vendue],

     [Sales 3 Months / Forecasts 3 months],

     [Quantité engagement],

     [Stock Total CDIS],

     [Stock Sécu(JO)(R1)],

     [* SSV],

     [Stock Maxi(JO)(R1)],

     [Quantité Prévue(R2)],

     [* Stock Target MIN [Packs]]],

     [* Stock Target MAX [Packs]]],

     [* RAG Delay [Packs]]],

     [* Stock Mkt  ONLY],

     [Stock Total MKT],

     [Stock Transit MKT],

     [* MKT Coverage [in months]]],

     [* % of Stock Mkt missing to reach MIN Stk Target],

     [* RAG Delay [Packs]]1],

     [* SKU below MIN Target],

     [* SKU within the limits],

     [* SKU above MAX Target],

     [* RAG Excess [Packs]]],

     [* % of Stock Mkt above MAX Stock Target],

     [* % of Stock Within the TARGETS],

     [% RAG/(RAG+BAD) 3 mois(R0)],

  

ApplyMap('List_EM',[GMID Code(R1)],'unknown') as [EM Entity],

     ApplyMap('List_EMSub',[GMID Code(R1)],'unknown') as [EM Sub Entity],

     ApplyMap('List_CMO',[GMID Code(R1)],'unknown') as [CMO Subcontractor ISL],

     Lookup('Product RTPI','GMID Code',[GMID Code(R1)],'RTPI_September') as [RTPI ISL],

     Lookup('ABC Standard Class Value','GMID Code',[GMID Code(R1)],'Class_ABC_September') as [Class ABC],

     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 €],

     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 €],

     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 €],

     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 €],

     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Delay [Packs]1"),'0,0') as [under stock in value €],

     num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]

From

(ooxml, embedded labels, header is 2 lines, table is [Data base$])

5 Replies

Re: Syntax error, missing/misplaced FROM

There are at least the semi-colons missing - after the load-statements:

...

num((Lookup('cri 2017','GMID Code',[GMID Code(R1)],'CRI_2017')*"* RAG Excess [Packs]"),'0,0') as [over stock in value €]

From

(ooxml, embedded labels, header is 2 lines, table is [Data base$]);

SLA_RAG_September:

Join(ISL_RAG)

...

- Marcus

shraddha_g
Honored Contributor III

Re: Syntax error, missing/misplaced FROM

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

Also ; is missing at the end of the statement.

Not applicable

Re: Syntax error, missing/misplaced FROM

Thanks a lot , the problem is solved .

Not applicable

Re: Syntax error, missing/misplaced FROM

Thank you very much , it's working for me.

oknotsen
Honored Contributor III

Re: Syntax error, missing/misplaced FROM

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).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!