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: 
evansabres
Specialist
Specialist

Count Records as of a Date

I am trying to count the number of records as of a certain date. Field I am trying to Count is 'ContactID' and the date field is 'CreatedDate'.

What would the structure of an expression be to count as of Today minus 7 days for example

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

try somethign like below

 

count({< Date={"<=$(=today()-7)"}>}Measure)

does count for dates less than or equal to 7 days back from today

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

try somethign like below

 

count({< Date={"<=$(=today()-7)"}>}Measure)

does count for dates less than or equal to 7 days back from today

Vegar
MVP
MVP

Try to create a expression like this. It wil count the ContactID associated with CreateDate in the 7 days interval ( today and  6 days before)

=Count({<CreateDate = {">$(=today()-7) <=$(=today())"}>}ContactID)