topic Error in expression: ')' expected in QlikView

Error in expression: ')' expected

Tue, 13 Sep 2016 15:23:03 GMT

Im trying to load the following script:

MAP_NFONDOS:

Mapping

LOAD

Codigo_Ppal_Corto_Key,

Count([DISTINCT]Producto_Cod_AñoMes_Key) as N_Fondos_Cliente

Resident F_OPERACIONES_SALDO

Where Tipo_Dato = 'Saldo'

Group by Codigo_Ppal_Corto_Key;

I don´t know where is the mistake, could you please help me?

Regards

sunny_talwar — Tue, 13 Sep 2016 15:51:11 GMT

May be try this:

MAP_NFONDOS:

Mapping

LOAD Codigo_Ppal_Corto_Key,

Count(DISTINCT [Producto_Cod_AñoMes_Key]) as N_Fondos_Cliente

Resident F_OPERACIONES_SALDO

Where Tipo_Dato = 'Saldo'

Group by Codigo_Ppal_Corto_Key;