topic Re: See new debtors per month in QlikView

See new debtors per month

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: See new debtors per month

vinieme12 — Mon, 13 Mar 2017 12:34:56 GMT

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}

Re: See new debtors per month

migueldelval — Mon, 13 Mar 2017 12:36:10 GMT

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

Re: See new debtors per month

Mon, 13 Mar 2017 13:38:32 GMT

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