Qlik Community

Qlik Sense App Development

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

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Error code script - Doesnt work Data Manager

I just added to script loader a line, this:

 

[SH_historico_1]:
LOAD
[ANOMES] AS [SH_historico_1.ANOMES],
APPLYMAP( 'TIP_TARMapping', [TIP_TAR]) AS [SH_historico_1.TIP_TAR],
[MARCA_RENEG] AS [SH_historico_1.MARCA_RENEG],
[MONTO] AS [SH_historico_1.MONTO],
[TRAMOMORA] AS [SH_historico_1.TRAMOMORA],
[DIA_PAGO] AS [SH_historico_1.DIA_PAGO],
[CASOS] AS [SH_historico_1.CASOS],
[CANAL] AS [SH_historico_1.CANAL],
[TRAMO_PAGO] AS [SH_historico_1.TRAMO_PAGO],
[DIAS_AL_CIERRE] AS [SH_historico_1.DIAS_AL_CIERRE],
[TIPO_MORA] AS [SH_historico_1.TIPO_MORA],
[ANOMES]&[TIPO_MORA]&(APPLYMAP( 'TIP_TARMapping', [TIP_TAR])) AS [SH_historico_1.ANOMES-SH_historico_1.TIPO_MORA-SH_historico_1.TIP_TAR-ANO_MES-TramoMora_Bucket-TIPO_PRODUCTO],
Makedate(Left([ANOMES],4),Right([ANOMES],2)) as Date;
SQL SELECT "ANOMES",
"TIP_TAR",
"MARCA_RENEG",
"MONTO",
"TRAMOMORA",
"DIA_PAGO",
"CASOS",
"CANAL",
"TRAMO_PAGO",
"DIAS_AL_CIERRE",
"TIPO_MORA"
FROM "DL_RG_ANALYTICS"."SH_historico_1";

 

I just added this line: Makedate(Left([ANOMES],4),Right([ANOMES],2)) as Date;

And now doesnt work data manager, it show that "Sync script"

 

How can I fix this? It could be fix?

 

Labels (2)