Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Count Rows if Date Entered within last 7 days

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

1 Solution

Accepted Solutions
jpapador
Partner - Specialist
Partner - Specialist

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))

View solution in original post

5 Replies
jpapador
Partner - Specialist
Partner - Specialist

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

alec1982
Specialist II
Specialist II
Author

Hi,

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

Best,

Alec

jpapador
Partner - Specialist
Partner - Specialist

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))

mov
Employee
Employee

A small correction:

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

Regards,

Michael

alec1982
Specialist II
Specialist II
Author

Thank you!