Datewise finding new user/Client from Orders table

[#1]

Dear All, i have table where client place the orders, my requirement is to get datewise new Client Count, once the client is already appear on previous days that should be not count again . below are the sample Data and Result Information .

sample Table ( * 'NEW' Column is just added for reference purpose only )

Date	Client	Orders
1/1/2014	A	200	NEW
1/1/2014	B	100	NEW
1/1/2014	C	200	NEW
1/2/2014	A	300
1/2/2014	D	400	NEW
1/2/2014	C	100
1/3/2014	A	300
1/3/2014	B	400
1/3/2014	D	100
1/4/2014	E	400	NEW
1/4/2014	F	200	NEW
1/4/2014	A	400

Result Table

Date	NEW Client Count
1/1/2014	3
1/2/2014	1
1/3/2014	0
1/4/2014	2

[senarath]

Hi,

You can use where exist and please refer bellow link

Understanding EXISTS() function - Qlikview vs SQL/RDBMS

Thanx

Senarath

[#3]

Dear Senarath, Its is not related to Exist() function. i have not to do anythings with new records or duplicate records, its just a report which have to show how often new client is placing orders

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[ashfaq_haseeb · Accepted solution]

Like this

Regards

ASHFAQ

[jonathandienst]

Hi

I would add a 'NEW' flag during load (using Exist() as already suggested). Something along the lines of:

     LOAD Client,

          If(Exist(Client)), 0, 1) As NewFlag,

          ...

(If the data source is not in date order, then do this in a sorted resident load)

Then your table becomes"

          Dimension - Date

          Expression - Count({<NewFlag = {'1'}>} Client)

HTH

Jonathan

[#7]

Its is fine but if the client place order in a day multiple time then the count get disturb and also i want to know.. Is this not possible by other way. the actual data is very big amount and with various other fields also.

[senpradip007]

PFA. Hope it will help you.

[ashfaq_haseeb]

then use distinct client count

Regards

ASHFAQ

[#10]

Thanks ALL