Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

carlospulgarinz
New Contributor

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

Tags (1)
1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Group By

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

3 Replies
omarbensalem
Esteemed Contributor

Re: Group By

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
Valued Contributor

Re: Group By

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

carlospulgarinz
New Contributor

Re: Group By

Thak you, It works Perfectly.