topic Re: AutoGenerate Years in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/1128270#M917974 <HTML><HEAD></HEAD><BODY><P>Make sense. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 May 2016 01:21:28 GMT sunny_talwar 2016-05-12T01:21:28Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/1128267#M917971 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1128267#M917971 microwin88x 2020-11-25T16:16:04Z Re: AutoGenerate Years https://community.qlik.com/t5/QlikView/Solved/m-p/1128268#M917972 <HTML><HEAD></HEAD><BODY><P>Just these values? How are they going to be linked to your other database? May be this if this is an Island table</P><P></P><P><STRONG>LOAD Year(Today()) - RecNo() + 1 as Year</STRONG></P><P><STRONG>AutoGenerate 3;</STRONG></P></BODY></HTML> Thu, 12 May 2016 01:10:35 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1128268#M917972 sunny_talwar 2016-05-12T01:10:35Z Re: AutoGenerate Years https://community.qlik.com/t5/QlikView/Solved/m-p/1128269#M917973 <HTML><HEAD></HEAD><BODY><P>Thanks! It worked. Yes, I'm using those values to keep a field with the years I want to filter in a table with where exists clause in order to get it optimized.</P></BODY></HTML> Thu, 12 May 2016 01:18:57 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1128269#M917973 microwin88x 2016-05-12T01:18:57Z Re: AutoGenerate Years https://community.qlik.com/t5/QlikView/Solved/m-p/1128270#M917974 <HTML><HEAD></HEAD><BODY><P>Make sense. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 May 2016 01:21:28 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1128270#M917974 sunny_talwar 2016-05-12T01:21:28Z