Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Group by in Load

Hi!,

I havbe a problem when i include a sentence group by in a load sentence, give a error but i don't understand why,

udp_hh:

LOAD
@IdUserDaily,
 
COMPANY,
 
WORKGROUP,
 
@Fecha,
 
HORA_MIN,
USERNAME,
trim(upper(USERNAME)) as RUT,
SUM(TIMEUSERLOGGEDIN) as TIMEUSERLOGGEDIN ,
 
FULLNAME

FROM $(PathQvd)user_daily_????.qvd (qvd)
WHERE COMPANY='LIPIGAS'
GROUP BY USERNAME
;

please help me, thanks a lot!

Tags (2)
1 Reply
Not applicable

Re: Group by in Load

You have to group all the columns that you did not execute any calculation such as Count, Sum etc..

Exemple:

LOAD A, B, SUM(C), COUNT(D)

FROM X

GROUP BY A, B

Best.