topic Re: Data filter based on years in QlikView https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695851#M1055754 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P></P><P>I tried the above expression before.But filtering the data is not working properly.</P><P></P><P>Regards</P><P></P><P>Krishna</P></BODY></HTML> Sun, 26 Oct 2014 12:12:18 GMT krishna20 2014-10-26T12:12:18Z Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695843#M1055746 <HTML><HEAD></HEAD><BODY><P>Hi friends ,</P><P></P><P>I'm having car models no like 01,02,03,04,05,06,07,08,09,10.......................</P><P>I need to filter the car models which are belongs to current year. i.e ; cars manufactured in 2014.</P><P>Having Fields as Veh_Model and Veh_Model_Year</P><P></P><P>Please anyone can help me how to resolve this issue.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Sun, 26 Oct 2014 09:45:56 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695843#M1055746 krishna20 2014-10-26T09:45:56Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695844#M1055747 <HTML><HEAD></HEAD><BODY><P>This is simply straight forward solution.</P><P>If you select year, it will show all the cars belong to that particular year.</P><P>If not then come-up with some sample data.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 26 Oct 2014 10:18:49 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695844#M1055747 ashfaq_haseeb 2014-10-26T10:18:49Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695845#M1055748 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq ,</P><P></P><P>I Agree with you. But i need to show filtered data directly in list box.</P><P>using Expression in List Box.</P></BODY></HTML> Sun, 26 Oct 2014 10:59:07 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695845#M1055748 krishna20 2014-10-26T10:59:07Z Re: Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695846#M1055749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a look at attached application.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 26 Oct 2014 11:09:49 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695846#M1055749 ashfaq_haseeb 2014-10-26T11:09:49Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695847#M1055750 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P>Thank you for your quick response. I'm Having model years from 1979 to future years. I need to show data for current and last two years. How it will be possible.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Sun, 26 Oct 2014 11:44:25 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695847#M1055750 krishna20 2014-10-26T11:44:25Z Re: Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695848#M1055751 <HTML><HEAD></HEAD><BODY><P>Like this.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 26 Oct 2014 11:50:08 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695848#M1055751 ashfaq_haseeb 2014-10-26T11:50:08Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695849#M1055752 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq ,</P><P></P><P>Thank you for your Response.you are right as per my requirement . Data i'm having is wrong.The max year i'm having 2088.Its not possible to do it as per my knowledge.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Sun, 26 Oct 2014 12:00:47 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695849#M1055752 krishna20 2014-10-26T12:00:47Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695850#M1055753 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Its possible, we are not using max(year) instead we are using.</P><P>=if(Veh_Model_Year=year(today()),Veh_Model)</P><P></P><P>I don't think there is any issue.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 26 Oct 2014 12:03:34 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695850#M1055753 ashfaq_haseeb 2014-10-26T12:03:34Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695851#M1055754 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P></P><P>I tried the above expression before.But filtering the data is not working properly.</P><P></P><P>Regards</P><P></P><P>Krishna</P></BODY></HTML> Sun, 26 Oct 2014 12:12:18 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695851#M1055754 krishna20 2014-10-26T12:12:18Z Re: Data filter based on years https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695852#M1055755 <HTML><HEAD></HEAD><BODY><P>Can you share your sample application.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 26 Oct 2014 12:13:38 GMT https://community.qlik.com/t5/QlikView/Data-filter-based-on-years/m-p/695852#M1055755 ashfaq_haseeb 2014-10-26T12:13:38Z