Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Error in expression: ')' expected

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;

1 Reply
sunny_talwar
Not applicable

Re: Error in expression: ')' expected

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;