topic How to get the minimum and maximum selected values in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-minimum-and-maximum-selected-values/m-p/413802#M489565 <HTML><HEAD></HEAD><BODY><P>How do I get the minimum and maximum selected values from a list box?</P><P></P><P>I have a list box filled with dates.&nbsp; I want to find the minimum date selected and the maximum date selected.&nbsp; Here is an example</P><P></P><P>Let us say I have 10 selected dates.</P><P></P><P>1/5/2012</P><P>1/6/2012</P><P>1/7/2012</P><P>1/8/2012</P><P>1/9/2012</P><P>1/26/2012</P><P>1/27/2012</P><P>1/28/2012</P><P>1/29/2012</P><P>1/30/2012</P><P></P><P>I want to get 1/5/2012 for my minimum and 1/30/2012 for my maximum.</P><P></P><P></P><P>Second part.&nbsp; What would the expression look if I wanted to sum a field for all the days between my minimum and maximum range of selected dates?&nbsp; So between 1/5/2012 AND 1/30/2012.</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 07 Nov 2012 21:56:45 GMT 2012-11-07T21:56:45Z How to get the minimum and maximum selected values https://community.qlik.com/t5/QlikView/How-to-get-the-minimum-and-maximum-selected-values/m-p/413802#M489565 <HTML><HEAD></HEAD><BODY><P>How do I get the minimum and maximum selected values from a list box?</P><P></P><P>I have a list box filled with dates.&nbsp; I want to find the minimum date selected and the maximum date selected.&nbsp; Here is an example</P><P></P><P>Let us say I have 10 selected dates.</P><P></P><P>1/5/2012</P><P>1/6/2012</P><P>1/7/2012</P><P>1/8/2012</P><P>1/9/2012</P><P>1/26/2012</P><P>1/27/2012</P><P>1/28/2012</P><P>1/29/2012</P><P>1/30/2012</P><P></P><P>I want to get 1/5/2012 for my minimum and 1/30/2012 for my maximum.</P><P></P><P></P><P>Second part.&nbsp; What would the expression look if I wanted to sum a field for all the days between my minimum and maximum range of selected dates?&nbsp; So between 1/5/2012 AND 1/30/2012.</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 07 Nov 2012 21:56:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-minimum-and-maximum-selected-values/m-p/413802#M489565 2012-11-07T21:56:45Z Re: How to get the minimum and maximum selected values https://community.qlik.com/t5/QlikView/How-to-get-the-minimum-and-maximum-selected-values/m-p/413803#M489566 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>=sum({&lt;Date = {'&gt;=$(=vMin)&lt;=$(=vMax)'}&gt;}Sales)</P><P></P><P>where vMin = Min(Date)</P><P>vMax = Max(Date)</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 07 Nov 2012 22:03:38 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-minimum-and-maximum-selected-values/m-p/413803#M489566 MayilVahanan 2012-11-07T22:03:38Z