Skip to main content

App Development

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

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 
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?

2 Replies

Why not simple select this years dates?

talk is cheap, supply exceeds demand
Contributor III
Contributor III

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.