topic Re: Date range in set analysis in QlikView

Date range in set analysis

lsmith48461 — Thu, 10 Jan 2019 22:12:04 GMT

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

Re: Date range in set analysis

uacg0009 — Fri, 11 Jan 2019 02:12:15 GMT

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

Re: Date range in set analysis

lsmith48461 — Fri, 11 Jan 2019 13:42:39 GMT

Yes, that worked. Thanks.

Re: Date range in set analysis

uacg0009 — Mon, 14 Jan 2019 02:28:08 GMT

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