QlikView App Dev

[alec1982]

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]

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

[alec1982]

Hi,

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

Best,

Alec

[jpapador · Accepted solution]

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]

A small correction:

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

Regards,

Michael

[alec1982]

Thank you!