Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes