Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kryan
Contributor II
Contributor II
‎2021-08-12 10:58 AM

YTD date range on sheet action

I am trying to create a sheet action that only gives me the YTD dates when opening the app.  I tried using ='>=today(2)-365<=today(2), but it was unsuccessful. Any suggestions?

603 Views
0 Likes
1 Reply
kaushiknsolanki
MVP
MVP
‎2021-08-12 01:54 PM

Try this.

=Date>=Yearstart(today())

The Date is the name of the Date Field.

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
569 Views
0 Likes