Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script doesn´t work as should

Hi all,

I have a script that works many days ago, but now doesnt.

OLEDB CONNECT TO .......;

Cabeceras_Temp:

NoConcatenate

Load

[Codi_local]

           ,[Servicio]

      ,[Nume_docum]

      ,[Codi_clien]

      ,[Codi_emple]

      ,[Nume_perso]

      ,[Año]

            ,[Mes]

            ,date(Fech_docum,'MM/DD/YYYY') as [Fech_docum]

            ,[Semanas]

            ,[Periodos]

            ,[Año_periodo]

            ,[Weekpart]

            ,[Daypart]

            ,[Hora]

      ,[Tipo_pagos]

      ,[Tota_docum]

      ,[Dcto_docum]

      ,[Tiva_docum]

      ,[Tser_docum]

      ,[Reca_docum]

      ,[Cobr_docum]

      ,[Esta_docum]

      ,[Cant_promo]

      ,[Neto_docum]

;

SELECT [Codi_local]

           ,CASE WHEN codi_docum = 'R' THEN 'Restaurante' WHEN codi_docum IN ('L', 'S') THEN 'Llevar' WHEN codi_docum = 'E' THEN 'Express' WHEN codi_docum IN ('D', 'C') THEN 'Domicilio' END AS [Servicio]

      ,[Nume_docum]

      ,[Codi_clien]

      ,[Codi_emple]

      ,[Nume_perso]

      ,DATEPART(YEAR, Fech_docum) AS [Año]

            ,DATEPART(M, Fech_docum) AS [Mes]

            ,[Fech_docum]

            ,[Semanas]

            ,[Periodos]

            ,[Año_periodo]

            ,CASE WHEN DATENAME(DW, Fech_docum) IN ('Lunes', 'Martes', 'Miércoles', 'Jueves') THEN 'Weekday' ELSE 'Weekend' END AS [Weekpart]

            ,[Daypart]

            ,round([Hora_docum],0,1) as [Hora]

      ,[Tipo_pagos]

      ,[Tota_docum]

      ,[Dcto_docum]

      ,[Tiva_docum]

      ,[Tser_docum]

      ,[Reca_docum]

      ,[Cobr_docum]

      ,[Esta_docum]

      ,[Cant_promo]

      ,[Neto_docum]

  FROM [Sodetur_PH_BI].[Express].[Moc_docu]

JOIN  [REPORTES].Parametros_daypart AS parametros

ON ( (round(hora_docum,0,1) between parametros.HORA_INI AND parametros.HORA_FIN))

JOIN  Reportes.Parametros_periodos periodos

on ( Fech_docum between periodos.fecha_inicio AND periodos.fecha_fin)

where codi_docum in('S','L','E','D','C','R')

  and Esta_docum='C' and Fech_docum > $(vUltFecha);

the strange part is when i delete "and Fech_docum > $(vUltFecha)" the script runs fine, but i need this filter. I take the script part on debugg mode when the variable is set with date, and sql server give me the set for the query, then i replace the variable with '07/24/2013', into qlikview still not working, but sql server give me the set again.

I haven´t idea about whats wrong or what happen. Someone can help me?

Thanks in advance,

Santiago.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

seems, it's a date format issue. check the date format of Fech_docum at sql server and make the variable hold the similar format date, it should work then.

View solution in original post

2 Replies
tresesco
MVP
MVP

seems, it's a date format issue. check the date format of Fech_docum at sql server and make the variable hold the similar format date, it should work then.

Not applicable
Author

You´re right, well, what i did was change 07/24/2013 into 24/07/2013 and ran fine, then i add a set format for variable

LET

vUltFecha = date(Peek('FechaMaxima', 0),'DD/MM/YYYY');

Thanks,

Santiago.