Group By

[carlospulgarinz]

Can someone help me I have This:

LIB CONNECT TO 'CRM PST';

LOAD

id_usuario,

nro_comparendo;

[vinfraccionesmcccali]:

SELECT "id_usuario",

"nro_comparendo"

FROM "oracle"."vinfraccionesmcccali";

But i need to

          1. Count nro_comparendo 

          2. Gruop By Id_usuario

[OmarBenSalem · Accepted solution]

LIB CONNECT TO 'CRM PST';

LOAD

id_usuario,

count(nro_comparendo) as Nbre

group by id_usuario;

;

[vinfraccionesmcccali]:

SELECT "id_usuario",

"nro_comparendo"

FROM "oracle"."vinfraccionesmcccali";

[tomasz_tru]

GROUP BY is ineffective in qlik. It is recommended to do it on the source database level.

[carlospulgarinz]

Thak you, It works Perfectly.