Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to data in a QlikSense tab to be locked down to current month and proceeding 2 months.
Is it possible to set the date dimension to current month and proceeding 2 months?
e.g. Current month is May 2019, so the data i would like to show is May 2019, June 2019, July 2019.
Similarly when current month is June 2019, then data i would like to be included in the tab is June 2019, July 2019, August 2019.
hi
you can create a bookmark
assuming your date field name is DATA
in the search of the field insert this expression
=DATE>=monthstart(today()) and DATE<=monthend(addmonths(today(),2))
and select the result ,
now create a bookmark
after creating a bookmark , you'll be able to see in the bookmark info that it uses the formula so it's a dynamic selection
now you can either set this as default bookmark , which means that when you open the app the selection will be made
or use a button in the desired sheet to apply the bookmark
you can refer to this video
=monthstart(today(),3)