Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mrjohn23
Contributor III

SELECT IN FIELD

I have the below list box with a trigger for Select in Field MAX(Month)

Can I take this a step further and have the last 3 values always selected.(Data is always updating) I saw a post that uses variables for latest and previous month using variables but can this be done without using variable?

=MAX(ENDDATE_YYYYMM)

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: SELECT IN FIELD

May be like this:

='>=' & MAX(ENDDATE_YYYYMM, 3)

3 Replies
galax_allu
Valued Contributor

Re: SELECT IN FIELD

may be with Firstsortedvalue() !

Re: SELECT IN FIELD

What's the problem with variable

From here, What you want to select

May be this?

Max(DateField,3)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: SELECT IN FIELD

May be like this:

='>=' & MAX(ENDDATE_YYYYMM, 3)