highest value in filter selection

[qlikviewwizard]

Hi All,

I want to show always max(DEPTNO) filter in the report.

For example, DEPTNO are 10,20,30,40 are there. When I open the report, It should be seleted DEPTNO=40.

How to achieve this?

[Anonymous · Accepted solution]

You can achieve this using a document trigger. Go to Document Properties >> Triggers >> OnOpen >> Add Actions >> Select in Field

Give DEPTNO as Field and search string as =max(DEPTNO)