topic Re: Set Analysis date, 2 conditions in QlikView

Set Analysis date, 2 conditions

LearnFreak — Sat, 10 Sep 2022 16:00:30 GMT

Hi,

I have a set analysis and need to restrict the range of the maxmim date to -1 -

=max({<BREAK={'5Days'}>}date(DATE))

I tried like this but I have an error -

=max({<BREAK={'5Days'}, DATE = {Today()-1}>}date(DATE)) and

=max({<BREAK={'5Days'}>+< DATE = {Today()-1}>}date(DATE))

Do you have any other idea?

Thanks.

BrunPierre — Sat, 10 Sep 2022 22:17:22 GMT

=max({<BREAK={'5Days'}, DATE = {'$(=Date(today()-1))'}>}date(DATE))

LearnFreak — Sat, 10 Sep 2022 22:48:21 GMT

Hi, I tried it like that but now the whole chart dissapeared.

I tried like this -

=max({<BREAK={'5Days'}>}date((DATE)-1))

and it showed for example if the Last date was 9th of September, it showed 8th of September...

but I am not sure if it is the correct result.

BrunPierre — Sun, 11 Sep 2022 08:23:53 GMT

In fact, the above expression will return the '8th of September' only for the value of BREAK which is “5Days".

Are you expecting a different outcome? Perhaps you could share some data and want you to hope to achieve.

LearnFreak — Wed, 21 Sep 2022 12:34:38 GMT

I solved it like this -

=max({<BREAK={'5Days'}>}date((DATE)-1))

and it worked perfectly. In fact it gave the maximum date - 1.