topic Selecting One & Half year data in QlikView https://community.qlik.com/t5/QlikView/Selecting-One-Half-year-data/m-p/315936#M116557 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do you select a year and a half data at a go from the check box to filter the entire data to contain only the relevant data. </P></BODY></HTML> Thu, 01 Sep 2011 10:38:48 GMT 2011-09-01T10:38:48Z Selecting One & Half year data https://community.qlik.com/t5/QlikView/Selecting-One-Half-year-data/m-p/315936#M116557 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do you select a year and a half data at a go from the check box to filter the entire data to contain only the relevant data. </P></BODY></HTML> Thu, 01 Sep 2011 10:38:48 GMT https://community.qlik.com/t5/QlikView/Selecting-One-Half-year-data/m-p/315936#M116557 2011-09-01T10:38:48Z Selecting One & Half year data https://community.qlik.com/t5/QlikView/Selecting-One-Half-year-data/m-p/315937#M116558 <HTML><HEAD></HEAD><BODY><P>You are talking about filtering a list box? If your dimension displayed in the list box is 'Date' and Date field is of date type, I would open the search field by clicking the magnifying class in the caption of the list box and enter</P><P></P><P>=Date&gt;addmonths(today(),-18)</P><P></P><P>to filter the last one and a half year of dates.</P><P>Or soemthing like</P><P></P><P>=Date&lt;addmonths(today(),-6) and Date&gt;addmonths(today(),-24)</P><P></P><P>to filter the date range two years back until 6 months back (1,5 years range).</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Thu, 01 Sep 2011 11:50:50 GMT https://community.qlik.com/t5/QlikView/Selecting-One-Half-year-data/m-p/315937#M116558 swuehl 2011-09-01T11:50:50Z