Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lsmith48461
Partner - Contributor
Partner - Contributor

Date range in set analysis

I have a chart which worked fine in 11.2 SR 15. This is part of the set analysis which restricted dates to today - 7. We just upgraded to November 2018 and this no longer works. Any suggestions?

Date={">=$(=max({1}Date)-7)"

 

1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

Hi,
Please mark my reply as "solution", so other people will know that the question is solved.
Thanks.
Aiolos Zhao

View solution in original post

3 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi Lsmith,
Please make sure that the format of "=max({1}Date)-7)" is same with "Date".
Please try : Date = {">=$(=date(max({1}Date)-7))"}
Aiolos Zhao
lsmith48461
Partner - Contributor
Partner - Contributor
Author

Yes, that worked. Thanks.

uacg0009
Partner - Specialist
Partner - Specialist

Hi,
Please mark my reply as "solution", so other people will know that the question is solved.
Thanks.
Aiolos Zhao