Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I am loading several seperate datasets which all look something like this;
CUSTOMER_id | INFO |
---|---|
0100 | A |
0200 | B |
0300 | C |
0200 | A |
0100 | B |
I am concatenating the datasets on load and once that is done I want the load script to assign a count to each CUSTOMER_id.
So for the example above I would like to see this;
CUSTOMER_id | INFO | Customer_Count |
---|---|---|
0100 | A | 2 |
0200 | B | 2 |
0300 | C | 1 |
0200 | A | 2 |
0100 | B | 2 |
How can I set and store the count?
Thanks
JW
a:
LOAD CUSTOMER_id,
INFO
FROM
[https://community.qlik.com/thread/165076]
(html, codepage is 1252, embedded labels, table is @1);
left join (a)
LOAD CUSTOMER_id, count(CUSTOMER_id) as Customer_Count Resident a group by CUSTOMER_id;
a:
LOAD CUSTOMER_id,
INFO
FROM
[https://community.qlik.com/thread/165076]
(html, codepage is 1252, embedded labels, table is @1);
left join (a)
LOAD CUSTOMER_id, count(CUSTOMER_id) as Customer_Count Resident a group by CUSTOMER_id;
Try this script:
Table:
LOAD CUSTOMER_id,
INFO
FROM
[https://community.qlik.com/thread/165076]
(html, codepage is 1252, embedded labels, table is @1);
Join (Table)
LOAD CUSTOMER_id,
Count(CUSTOMER_id) AS Customer_Count
Resident Table
Group By CUSTOMER_id;
mayba also in a chart
2 dimension CUSTOMER_id INFO
expression count(TOTAL <CUSTOMER_id> CUSTOMER_id)
Hi Massimo
Wow, that was quick!
Fantastic, this worked perfectly. Thank you so much.
JW
Sunindia
Fab, thank you.
JW