Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

See new debtors per month

Hello everyone,

I want to create a graph chart which shows the amount of new debtors per month.

I'm using logfiles as data and these logfiles are created each day. Every day is a new logfile.

The problem I'm running into is that I want to count each debtor only the first time they got logged.

I can't use a distinct count, because if I show the amount of debtors per month, then the debtors who were

online in february and march are counted as 1 in both months. I want it that when someone's first logged event is february, then the only month that debtor is counted in is february. If he is also online in march, he shouldnt be counted.

I hope someone can help me!

Thanks in advance

3 Replies
vinieme12
Champion III
Champion III

use Autonumber() this will assign numeric values for each instance , but you must sort the data by date

so for example if Debtor A was in the log file for Jan,feb,Mar, the entry for Jan will have autonumber value 1,2,3 respectively

So using set analysis filter out records with Autonumber value as {1}

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
migueldelval
Specialist
Specialist

Hi Ivo,

I think taht you need to make a link table with debtors and make a flag if it´s new or not.

Could you attach a data sample to understnad better your requirement?

Regards

Miguel del Valle

Not applicable
Author

Hey Miguel,

I unfortunately cant share the data i'm using, but I can try something with assigning a new or not to each debtor.

Thank You