Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion II
Champion II

Re: See new debtors per month

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}

Highlighted
Specialist
Specialist

Re: See new debtors per month

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

Highlighted
Not applicable

Re: See new debtors per month

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