topic Sum(Field) as a new field in Script in QlikView

Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:00:05 GMT

Hi Qlik Community !

I'm trying to create a new table with 2 fields: ID USER and SUM([NUMBER OF LOGIN]). However, when reload the data, the following error message is displayed:

Invalid expression

TOTALLOGIN:

LOAD [ID USER],

SUM([NUMBER OF LOGIN]) AS TOTAL_LOGINS

Resident LOGIN

My database is the following:

ID USER	CHANNEL	NUMBER OF LOGIN
1	INTERNET	4
1	MOBILE	9
2	INTERNET	3
2	MOBILE	3
3	INTERNET	6
3	MOBILE	1
4	INTERNET	5
4	MOBILE	8
5	INTERNET	6
5	MOBILE	8
6	INTERNET	9
7	INTERNET	8
8	INTERNET	8
9	INTERNET	3
10	INTERNET	4
11	MOBILE	10
12	MOBILE	2
13	MOBILE	5

And my script:

LOAD [ID USER],

CHANNEL,

[NUMBER OF LOGIN]

FROM

[PRUEBA_1.xlsx]

(ooxml, embedded labels);

TOTALLOGIN:

LOAD [ID USER],

SUM([NUMBER OF LOGIN]) AS TOTAL_LOGINS

Resident LOGIN;

Does someone know why the SUM function is not recognized as valid expression?

Thanks in advance !

Regards,

Vincent

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:01:58 GMT

you need group by your dimensions, it means the fields you want to keep

Fabrice

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:08:13 GMT

Hi,

Exactly, you just need

Resident LOGIN

Group By [ID USER]

;

Result in attached. Regards.

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:09:02 GMT

OMG, I didn't imagine it would be that easy...

Thanks a lot Fabrice!! This sentence works:

TOTALLOGIN:

LOAD [ID USER],

SUM([NUMBER OF LOGIN]) AS TOTAL_LOGINS

Resident LOGIN

Group by [ID USER];

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:09:50 GMT

Thanks Pierre !

🙂

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:18:04 GMT

Hi Vincent,

Please check the attached qvw. Were you expecting the same results??

Regards,

Varsha

Re: Sum(Field) as a new field in Script

Thu, 30 Jan 2014 10:26:12 GMT

Thanks a lot Varsha. These are the results I was expecting 🙂