Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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";
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";
GROUP BY is ineffective in qlik. It is recommended to do it on the source database level.
Thak you, It works Perfectly.