Dynamic filter to open app with max yearmonth

[1600eads]

I am having trouble setting up a dynamic filter so that a user will see the current month and year data when opening an app.

I followed Christoph video here - https://www.youtube.com/watch?v=tFyqOigqnUw

Also formatted by date using this expression in the script - 

(Date(monthstart(DATE_TEST), 'MMM-YYYY')) as NEW_DATE which looks like the img below.

Now directly within the search bar I am trying to grab the max/latest year month value which should be Jul-2020 using this expression.

=NEW_DATE=Monthstart(now())

This does nothing and unable to yield the Jul-2020 value I expected. Can anyone provide some feedback here? Thank you!

[rubenmarin]

Hi, now() will return today date, wich will be Jun-2024 and that value didn't exists, you can try with Max(), and also adding the date format, like: =NEW_DATE=Date(Max(DATE_TEST), 'MMM-YYYY')

First you can try to set this expression (=Date(Max(DATE_TEST), 'MMM-YYYY')) in a simple table to confirm that it returns the value you want to be selected.

[1600eads]

Still not yielding anything on my end. If I wanted it to return the current month and year - so July-2024, shouldnt the below expression work?

=NEW_DATE= month(monthstart(today()))

Much thanks Rubenmarin.

[1600eads · Accepted solution]

I was unable to mimic what Christoph did in his video using month(monthstart(today())) but found this thread and was able to use that expression and working as expected. I also want to note that I did this in the selection tool directly instead of on the sheet.

Here is the thread- https://community.qlik.com/t5/New-to-Qlik-Analytics/Dynamic-default-bookmarks/td-p/1805017

[1600eads]

If I wanted to grab the last 14 days any idea how to go about that?

I tried NEW_DATE=today()-14 and NEW_DATE=date(today())-14 but no luck there.

[rubenmarin]

Try setting the -14 inside the date, if you set outside it will end with number format instead of date:

NEW_DATE=date(today()-14)