Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
carlospulgarinz
Contributor III
Contributor III

Group By

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

1 Solution

Accepted Solutions
OmarBenSalem

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";

View solution in original post

3 Replies
OmarBenSalem

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
Specialist
Specialist

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

carlospulgarinz
Contributor III
Contributor III
Author

Thak you, It works Perfectly.