sum and group by date in data load

[q11hhg]

Hi there , 

I just started to use Qliksense . I want to know how to group and aggregate the data in the data load editor. 

The attached screenshot is what I want to achieve:

\

I used this script, but the result does not seem to be correct.

BNA_Login_Temp:

LOAD

"Customer_id lookUP"             AS "Customer ID",
Date("Date",'YYYY-MM-DD')      AS Date,
'1'                                                        AS "Total"

FROM [lib://AttachedFiles/BNA Logins.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate (APAC_Events)

BNA_Login:

Load
Date,
"Customer ID",
'Login'                                     AS "Event Type",
'BNA'                                        AS "Country",
Sum("Total")                         As "Total Events"

Resident BNA_Login_Temp
Group by "Customer ID",Date;
Drop Table BNA_Login_Temp;

[duchezbr]

You will get the desired result by removing 'Login' and 'BNA' when loading the BNA_Login table or add these fields to your Group by statement.

[q11hhg]

Hi @duchezbr 

I need these two columns on my table.

it should look like this actually.

BUT when use the calculation 

count( {<
[Event Type] = {'Login'},
[Total Events]={">=2"}
>} distinct [Customer ID] )

it does not return the correct result, so I assuming that there is an error in my data load 

[duchezbr · Accepted solution]

I am thinking it is the concatenation.  Does the APAC_Events have a key that you can join on. I can get the desired output with the following but I don't know if this is feasible:

inner join(APAC_Events)
BNA_login:
Load
Dates,
Customer_id,
Sum(Total)
Resident BNA_login_temp
Group by Dates, Customer_id;

[q11hhg]

Hi @duchezbr  thank you, the two tables have exactly same column names, but no key that can let me to join them as far as I know.

Basiaclly they are data from two different regions and there is no key. I need to append/concatenate them