Set Analysis date, 2 conditions, max date - 1

Learn Freak 0
Viewed 23

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?

set-analysis qlikview report visualization database
1 Answers

I solved it like this -

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

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

Learn Freak0
Related