Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shayd
Contributor III
Contributor III

Only this year- Table with no measures

Hi all,

I have a table holding only dimensions, no measures.
I wish to filter the table via a date field so only 2021 will show up using aggr & only (since I cant use set analysis).
The date field looks like this: dd/mm/yyyy
I've tried using  =aggr(only({<num(year(Date))={num(year(today()))}>}Date), Date)  to extract the year but all I get is nulls.

Any suggestions?
Thanks!

2 Replies
Gysbert_Wassenaar

Why not simple select this years dates?


talk is cheap, supply exceeds demand
shayd
Contributor III
Contributor III
Author

That's what I've been asked.
The table should show only certain year.
Basically I've succeeded in doing this using "if" but I wish to see if there is another option.