topic Re: Data load script is executed without error, but data is not loaded in QlikView

Data load script is executed without error, but data is not loaded

mluz — Mon, 26 Jan 2026 16:26:21 GMT

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

// Variable para que recorra los ultimos 12 meses
LET vPeriodo = DATE(ADDMONTHS(TODAY(),-i), 'YYYYMM');

SET vFILENAME = '[C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd]';

LET vFILESIZE = FILESIZE($(vFILENAME));

IF NOT IsNull(vFILESIZE) THEN

ORDENES_DETALLE_POR_PERIODO:
LOAD
*

FROM '[C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd]'(qvd);

ENDIF

Re: Data load script is executed without error, but data is not loaded

marcus_sommer — Tue, 02 Nov 2021 15:09:11 GMT

Try it in this way:

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

// Variable para que recorra los ultimos 12 meses
LET vPeriodo = DATE(ADDMONTHS(TODAY(),-i), 'YYYYMM');

SET vFILENAME = C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd;

LET vFILESIZE = FILESIZE('$(vFILENAME)');

IF NOT IsNull(vFILESIZE) THEN

ORDENES_DETALLE_POR_PERIODO:
LOAD
*

FROM [$(vFILENAME)](qvd);

ENDIF

- Marcus

Re: Data load script is executed without error, but data is not loaded

kiranpol — Thu, 13 Jan 2022 06:26:54 GMT

I surely that this will works for you. So please try it in this way:

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

ORDENES_DETALLE_POR_PERIODO:
LOAD
*
omegle
FROM [$(vFILENAME)](qvd);
cps test
ENDIF

Regards

KiranPol

Re: Data load script is executed without error, but data is not loaded

Jill_Masinde — Thu, 16 Jun 2022 21:39:17 GMT

@mluz

Did the suggestion solution help resolve this issue for you? Your feedback is important to us. Kindly respond by marking the Accept as Solution.

Thanks