Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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))

Anonymous
Not applicable

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!