Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Select in field: MAX value minus one

I need to set a list box to default to the two values after the max date. For example, see below.

I have the below expression but it does not work.

='>=' & MAX(ActiveMonth , 3)-1

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Select in field: MAX value minus one

How about:

='>=' & Date(MAX(ActiveMonth , 3)-1)&'<'&Date(MAX(ActiveMonth))

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Select in field: MAX value minus one

Format could be the issue. Try like:

='>=' & Date(MAX(ActiveMonth , 3)-1 , 'DD/MM/YYYY')

Highlighted
Creator III
Creator III

Re: Select in field: MAX value minus one

That doesn't work but the below selects all three.

='>=' & Date(MAX(ActiveMonth , 3)-1)

Highlighted
Master II
Master II

Re: Select in field: MAX value minus one

How about:

='>=' & Date(MAX(ActiveMonth , 3)-1)&'<'&Date(MAX(ActiveMonth))

View solution in original post