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: 
toddbuss
Creator
Creator

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
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Creator
Creator
Author

that fixed it.  Thanks.