topic Re: Min value over the aggregation in QlikView https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497638#M557822 <HTML><HEAD></HEAD><BODY><P>Try maybe something like</P><P></P><P>=min(aggr( if(DPML &gt;= round(Fractile(total&lt;RPT_DATE&gt; DPML,.75),.01),DPML),RPT_DATE,DPML))</P></BODY></HTML> Fri, 21 Jun 2013 21:11:33 GMT swuehl 2013-06-21T21:11:33Z Min value over the aggregation https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497637#M557821 <HTML><HEAD></HEAD><BODY><P>Hi All, I am trying to calculate the min value of the DPML (one of field) is greater than the or equal to the FRACTILE(DPML,0.75) value for that RPT_DAY.</P><P></P><P>I attached the qvw with sample data. Here below is looking for:</P><P></P><P>MIN(IF(DPML&gt;=FRACTILE(DPML,0.95),DPML,FRACTILE(DPML,0.75)))</P></BODY></HTML> Fri, 21 Jun 2013 20:39:30 GMT https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497637#M557821 2013-06-21T20:39:30Z Re: Min value over the aggregation https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497638#M557822 <HTML><HEAD></HEAD><BODY><P>Try maybe something like</P><P></P><P>=min(aggr( if(DPML &gt;= round(Fractile(total&lt;RPT_DATE&gt; DPML,.75),.01),DPML),RPT_DATE,DPML))</P></BODY></HTML> Fri, 21 Jun 2013 21:11:33 GMT https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497638#M557822 swuehl 2013-06-21T21:11:33Z Re: Min value over the aggregation https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497639#M557823 <HTML><HEAD></HEAD><BODY><P>Thanks swuehl.</P></BODY></HTML> Fri, 21 Jun 2013 23:51:16 GMT https://community.qlik.com/t5/QlikView/Min-value-over-the-aggregation/m-p/497639#M557823 2013-06-21T23:51:16Z