# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## basic set analysis woes

This formula shows all records that fall within the latest date in the set:

count({\$<[Date Submitted to TC]={">=\$(=max([Date Submitted to TC]))"}>}[Date Submitted to TC])

This formula should show all records that fall within the 7 days prior to the latest date in the set:

count({\$<[Date Submitted to TC]={">=\$(=max([Date Submitted to TC]))-7"}>}[Date Submitted to TC])

The first formula works, but the second doesn't.  I've been tinkering for hours trying to get this to work.   Any help would be appreciated.  Thanks.

1 Solution

Accepted Solutions
MVP

## Re: basic set analysis woes

Move -7 within the dollar sign expansion. You might also need Date() function with the date format of Date Submitted to TC

Count({\$<[Date Submitted to TC]={">=\$(=Date(Max([Date Submitted to TC])-7, 'DateFieldFormatHere'))"}>}[Date Submitted to TC])

2 Replies
MVP

## Re: basic set analysis woes

Move -7 within the dollar sign expansion. You might also need Date() function with the date format of Date Submitted to TC

Count({\$<[Date Submitted to TC]={">=\$(=Date(Max([Date Submitted to TC])-7, 'DateFieldFormatHere'))"}>}[Date Submitted to TC])

New Contributor III

## Re: basic set analysis woes

that fixed it.  Thanks.