topic Re: Display all the values excluding maximum and minimum value in QlikView https://community.qlik.com/t5/QlikView/Display-all-the-values-excluding-maximum-and-minimum-value/m-p/2492#M791708 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Refer to the attached output.</P><P>using below set analysis with date range method u can get the desired out.</P><P>sum( {$&lt;Date={"&gt;$(=Date(Min(Date)))&lt;$(=Date(Max(Date)))"}&gt;}Price)</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191597_Capture.JPG" style="height: 318px; width: 620px;" /></P></BODY></HTML> Sat, 27 Jan 2018 09:08:34 GMT devarasu07 2018-01-27T09:08:34Z Display all the values excluding maximum and minimum value https://community.qlik.com/t5/QlikView/Display-all-the-values-excluding-maximum-and-minimum-value/m-p/2491#M791707 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hello,</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I need to display all the values excluding maximum and minimum Price vale. Please find the excel data source.</SPAN><SPAN style="color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-all-the-values-excluding-maximum-and-minimum-value/m-p/2491#M791707 Vigneshvaran 2020-11-25T16:16:04Z Re: Display all the values excluding maximum and minimum value https://community.qlik.com/t5/QlikView/Display-all-the-values-excluding-maximum-and-minimum-value/m-p/2492#M791708 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Refer to the attached output.</P><P>using below set analysis with date range method u can get the desired out.</P><P>sum( {$&lt;Date={"&gt;$(=Date(Min(Date)))&lt;$(=Date(Max(Date)))"}&gt;}Price)</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191597_Capture.JPG" style="height: 318px; width: 620px;" /></P></BODY></HTML> Sat, 27 Jan 2018 09:08:34 GMT https://community.qlik.com/t5/QlikView/Display-all-the-values-excluding-maximum-and-minimum-value/m-p/2492#M791708 devarasu07 2018-01-27T09:08:34Z