https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875332#M72178 <P>That's what I've been asked.<BR />The table should show only certain year.<BR />Basically I've succeeded in doing this using "if" but I wish to see if there is another option.</P> Mon, 27 Dec 2021 15:49:39 GMT shayd 2021-12-27T15:49:39Z https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875099#M72164 <P>Hi all,<BR /><BR />I have a table holding only dimensions, no measures.<BR />I wish to filter the table via a date field so only 2021 will show up using aggr &amp; only (since I cant use set analysis).<BR />The date field looks like this: dd/mm/yyyy<BR />I've tried using&nbsp;&nbsp;<EM>=aggr(only({&lt;num(year(Date))={num(year(today()))}&gt;}Date), Date)&nbsp;&nbsp;</EM>to extract the year but all I get is nulls.<BR /><BR />Any suggestions?<BR />Thanks!</P> Sun, 26 Dec 2021 13:25:50 GMT https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875099#M72164 shayd 2021-12-26T13:25:50Z https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875317#M72177 <P>Why not simple select this years dates?</P> Mon, 27 Dec 2021 14:47:44 GMT https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875317#M72177 Gysbert_Wassenaar 2021-12-27T14:47:44Z https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875332#M72178 <P>That's what I've been asked.<BR />The table should show only certain year.<BR />Basically I've succeeded in doing this using "if" but I wish to see if there is another option.</P> Mon, 27 Dec 2021 15:49:39 GMT https://community.qlik.com/t5/App-Development/Only-this-year-Table-with-no-measures/m-p/1875332#M72178 shayd 2021-12-27T15:49:39Z