Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

toddbuss
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
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
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])

toddbuss
New Contributor III

Re: basic set analysis woes

that fixed it.  Thanks.