topic Re: Count debtors over a certain period in QlikView

Count debtors over a certain period

Wed, 25 Nov 2020 16:16:04 GMT

Hey everyone,

I'm having a problem with counting the amount of debtors from the last 28 days.

I have an expression which defines the last 28 days:
If(Today() - Date <= 28 And Today() - Date >= 0, 1, 0) As Date_IsLast28Days

And I need to show this in a single Text Object.

This is the expression I use in the text object.

=Count({< Date2 = {"Date_IsLast28Days"}>} DISTINCT Debtor)

The expression below is what I used before, but this only gives the amount of debtors from the day 28 days ago. Not the whole period of 28 days ago:

=Count({< Date2 = {"$(=date(today()-28))"}>} DISTINCT Debtor)

What I need is the amount of debtors from the last 28 days (28 days ago - until - yesterday).

I hope someone can help me out on this one!

PrashantSangle — Mon, 06 Mar 2017 14:35:34 GMT

Hi,

made below changes

=Count({< Date2 = {">=$(=date(today()-28))<=$(=date(today()))"}>} DISTINCT Debtor)

Regards,

aarkay29 — Mon, 06 Mar 2017 14:38:23 GMT

try this

for till date and >= last 28 days

=Count({< Date2 = {">=$(=date(today()-28))"}>} DISTINCT Debtor)

for till yesterday and >= last 28 days

=Count({< Date2 = {">=$(=date(today()-28))<=$(=date(today()-1))"}>} DISTINCT Debtor)

sunny_talwar — Mon, 06 Mar 2017 14:43:22 GMT

If you have created a flag for the last 28 days, why don't you use that?

=Count({<Date_IsLast28Days = {1}>} DISTINCT Debtor)