Discussion Board for collaboration related to QlikView App Development.
I havbe a problem when i include a sentence group by in a load sentence, give a error but i don't understand why,
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!
You have to group all the columns that you did not execute any calculation such as Count, Sum etc..
LOAD A, B, SUM(C), COUNT(D)
GROUP BY A, B