Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in expression: ')' expected

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

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

1 Reply
sunny_talwar

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;