topic Re: Count Rows if Date Entered within last 7 days in QlikView

Count Rows if Date Entered within last 7 days

alec1982 — Mon, 29 Jul 2013 17:22:49 GMT

Hi guys,

I have a table with couple of fields:

Name, Date Entered

A, 07/25/2013

B,07/26/2013

C, 05/05/2013

I need to do Count of Names if it was entered in the lat 7 days..

Any suggestions?

Nest,

Alec

jpapador — Mon, 29 Jul 2013 17:30:38 GMT

If([Date Entered] >= (Date(Today())-7), Count(Name))

alec1982 — Mon, 29 Jul 2013 17:47:56 GMT

Hi,

Thank you for the reply but for some reasons in the data there are future dates too..

Best,

Alec

jpapador — Mon, 29 Jul 2013 18:01:13 GMT

Then add a condition that it cannot be greater than today. For example,

If([Date Entered] >= (Date(Today())-7) and [Date Entered] <= Date(Today()) , Count(Name))

Anonymous — Mon, 29 Jul 2013 19:02:16 GMT

A small correction:

count (distinct if([Date Entered] >= Date(Today())-7 and [Date Entered] <=today(), Name))

Regards,

Michael

alec1982 — Mon, 29 Jul 2013 19:12:22 GMT

Thank you!