Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
lsmith48461
New 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
Valued Contributor

Re: Date range in set analysis

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

Re: Date range in set analysis

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
New Contributor

Re: Date range in set analysis

Yes, that worked. Thanks.

uacg0009
Valued Contributor

Re: Date range in set analysis

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