Discussion Board for collaboration on QlikView Scripting.
I am loading several seperate datasets which all look something like this;
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;
How can I set and store the count?
Go to Solution.
(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:
Count(CUSTOMER_id) AS Customer_Count
Group By CUSTOMER_id;
mayba also in a chart
2 dimension CUSTOMER_id INFO
expression count(TOTAL <CUSTOMER_id> CUSTOMER_id)
Wow, that was quick!
Fantastic, this worked perfectly. Thank you so much.
Fab, thank you.