topic Re: How to count instances on load in QlikView

How to count instances on load

Thu, 21 May 2015 16:25:00 GMT

Hi There

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?

Thanks

maxgro — Thu, 21 May 2015 16:29:06 GMT

LOAD CUSTOMER_id,

INFO

FROM

(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;

sunny_talwar — Thu, 21 May 2015 16:31:01 GMT

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;

maxgro — Thu, 21 May 2015 16:40:45 GMT

mayba also in a chart

2 dimension CUSTOMER_id INFO

expression count(TOTAL <CUSTOMER_id> CUSTOMER_id)

Thu, 21 May 2015 16:40:58 GMT

Hi Massimo

Wow, that was quick!

Fantastic, this worked perfectly. Thank you so much.

Thu, 21 May 2015 16:42:46 GMT

Sunindia

Fab, thank you.