topic Data Extraction in QlikView https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315735#M841833 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have my data in format yyyy-mm and I would like to have list box for year and month.</P><P>I have used Year(dataname) as year ... But it doesn't work. What is the way yo do it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Data Extraction https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315735#M841833 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have my data in format yyyy-mm and I would like to have list box for year and month.</P><P>I have used Year(dataname) as year ... But it doesn't work. What is the way yo do it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315735#M841833 2020-11-25T16:16:04Z Re: Data Extraction https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315736#M841834 <HTML><HEAD></HEAD><BODY><P>Year((Date#(&lt;your field&gt;,'YYYY-MM')))</P></BODY></HTML> Tue, 25 Apr 2017 15:54:38 GMT https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315736#M841834 Anonymous 2017-04-25T15:54:38Z Re: Data Extraction https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315737#M841835 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>try</P><P>Year(Date#(field,'YYYY-MM'))</P><P>and</P><P>Month(Date#(field,'YYYY-MM'))</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 25 Apr 2017 15:55:30 GMT https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315737#M841835 antoniotiman 2017-04-25T15:55:30Z Re: Data Extraction https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315738#M841836 <HTML><HEAD></HEAD><BODY><P>Thanks. It solved <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 26 Apr 2017 18:04:11 GMT https://community.qlik.com/t5/QlikView/Data-Extraction/m-p/1315738#M841836 2017-04-26T18:04:11Z