Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Datewise finding new user/Client from Orders table

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 )

DateClientOrders
1/1/2014A200NEW
1/1/2014B100NEW
1/1/2014C200NEW
1/2/2014A300
1/2/2014D400NEW
1/2/2014C100
1/3/2014A300
1/3/2014B400
1/3/2014D100
1/4/2014E400NEW
1/4/2014F200NEW
1/4/2014A400

Result Table

DateNEW Client Count
1/1/20143
1/2/20141
1/3/20140
1/4/20142
1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Like this

Regards

ASHFAQ

View solution in original post

9 Replies
senarath
Creator III
Creator III

Hi,

You can use where exist and please refer bellow link

Understanding EXISTS() function - Qlikview vs SQL/RDBMS

Thanx

Senarath

Not applicable
Author

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
Champion III
Champion III

Like this

Regards

ASHFAQ

ashfaq_haseeb
Champion III
Champion III

Like this

Regards

ASHFAQ

jonathandienst
Partner
Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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
Specialist III
Specialist III

PFA. Hope it will help you.

ashfaq_haseeb
Champion III
Champion III

then use distinct client count

Regards

ASHFAQ

Not applicable
Author

Thanks ALL