topic Re: Count the Customers in QlikView

Count the Customers

rajkumarb — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I need to count the number of customers over the time, in Load Script

but i need to create a new field with their number of visit added together

for better explanation i attached the xls with data and expected output

please suggest

vinieme12 — Thu, 05 Jan 2017 13:33:58 GMT

how is 12347 = 8 , when you only have 5 rows of data for each customer, can you explain in detail?

surendraj — Thu, 05 Jan 2017 13:47:25 GMT

Hi,

In your specified .xls file have only 5 records for all three customers.

am i relevent to your expected output?

--surendra

vinieme12 — Thu, 05 Jan 2017 13:49:19 GMT

Anyways, you can use below

count(TOTAL Date)

rajkumarb — Thu, 05 Jan 2017 13:51:15 GMT

please download the book1 again

i changed it

yes it is relevent

vinieme12 — Thu, 05 Jan 2017 13:52:05 GMT

try

count(TOTAL Date)

rajkumarb — Thu, 05 Jan 2017 13:53:53 GMT

In Load Script

vinieme12 — Thu, 05 Jan 2017 13:56:39 GMT

Use the Expression in Chart if you want in load

Then

FACT:

LOAD Customer_ID,

Date

FROM

(ooxml, embedded labels, table is Data);

left join(FACT)

Load Customer_ID,

Count(Customer_ID)

Resident FACT

GROUP BY Customer_ID;