topic Re: InYear query in QlikView https://community.qlik.com/t5/QlikView/InYear-query/m-p/940937#M955946 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>=InYear(DateField, Only(NewListBoxField))</STRONG></P><P></P><P>Where NewListBoxField will comprise of 01/01/2014, 01/01/2015, 01/01/2016 and you can always have one selected value</P></BODY></HTML> Thu, 19 Nov 2015 13:09:37 GMT sunny_talwar 2015-11-19T13:09:37Z InYear query https://community.qlik.com/t5/QlikView/InYear-query/m-p/940936#M955945 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am currently using the the "InYear" expression for a lot of the text box properties on my dashboard and so it uses only 2015 data.</P><P></P><P>Is there a way I can create a list box so when I select 2016 or 2014, the text properties will now equal that InYear=2014 and so on?</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 19 Nov 2015 12:58:28 GMT https://community.qlik.com/t5/QlikView/InYear-query/m-p/940936#M955945 knightwriter 2015-11-19T12:58:28Z Re: InYear query https://community.qlik.com/t5/QlikView/InYear-query/m-p/940937#M955946 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>=InYear(DateField, Only(NewListBoxField))</STRONG></P><P></P><P>Where NewListBoxField will comprise of 01/01/2014, 01/01/2015, 01/01/2016 and you can always have one selected value</P></BODY></HTML> Thu, 19 Nov 2015 13:09:37 GMT https://community.qlik.com/t5/QlikView/InYear-query/m-p/940937#M955946 sunny_talwar 2015-11-19T13:09:37Z