topic highest value in filter selection in QlikView https://community.qlik.com/t5/QlikView/highest-value-in-filter-selection/m-p/776876#M275368 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to show always max(DEPTNO) filter in the report.</P><P></P><P>For example, DEPTNO are 10,20,30,40 are there. When I open the report, It should be seleted DEPTNO=40. </P><P></P><P>How to achieve this?</P></BODY></HTML> Tue, 24 Mar 2015 09:00:24 GMT qlikviewwizard 2015-03-24T09:00:24Z highest value in filter selection https://community.qlik.com/t5/QlikView/highest-value-in-filter-selection/m-p/776876#M275368 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to show always max(DEPTNO) filter in the report.</P><P></P><P>For example, DEPTNO are 10,20,30,40 are there. When I open the report, It should be seleted DEPTNO=40. </P><P></P><P>How to achieve this?</P></BODY></HTML> Tue, 24 Mar 2015 09:00:24 GMT https://community.qlik.com/t5/QlikView/highest-value-in-filter-selection/m-p/776876#M275368 qlikviewwizard 2015-03-24T09:00:24Z Re: highest value in filter selection https://community.qlik.com/t5/QlikView/highest-value-in-filter-selection/m-p/776877#M275369 <HTML><HEAD></HEAD><BODY><P>You can achieve this using a document trigger. Go to Document Properties &gt;&gt; Triggers &gt;&gt; OnOpen &gt;&gt; Add Actions &gt;&gt; Select in Field</P><P></P><P>Give DEPTNO as Field and search string as =max(DEPTNO)</P></BODY></HTML> Tue, 24 Mar 2015 09:04:33 GMT https://community.qlik.com/t5/QlikView/highest-value-in-filter-selection/m-p/776877#M275369 Anonymous 2015-03-24T09:04:33Z