Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pablot_
New Contributor

Problem with Where sentnce in SAP

Hi, I try to create a filter in SAP with this Script

let S=date((today()-10),'YYYYMMDD');

[Remitos]:            //[CabeceraRemito]:

Load

          [VBELN] as Entrega,

          [ERDAT] as Fecha,                    //FechaCreado

          [ERZET] as HoraCreado,

          //LFDAT FechaEntrega

          [LPRIO] as Prioridad,,

          [KUNNR] as Destinatario,

          [KUNAG] as Solicitante,

          [ANZPK] as Bultos,

          [BTGEW] as PesoTotal,

          [XBLNR] as NroLegalRemito;

SQL Select VBELN ERDAT ERZET LPRIO KUNNR KUNAG ANZPK BTGEW LIFNR XBLNR from LIKP

where ERDAT>$(S);

any idea why i have a error in this script.

Regards 

1 Reply
MVP
MVP

Re: Problem with Where sentnce in SAP

Pablo

I am not sure which DBMS this is for, but I noticed a few things which may be issues:

  • double comma after Prioridad
  • shouldn't there be commas between the field names in the Select statement?
  • I suspect that the $(S) should be enclosed in quotes   where ERDAT>'$(S)'

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser