Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kristen_s
New Contributor II

How to set a date dimension to specific date range

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.

2 Replies
Partner
Partner

Re: How to set a date dimension to specific date range

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

https://www.youtube.com/watch?v=d85WIgy35Ig

Channa
Valued Contributor III

Re: How to set a date dimension to specific date range

=monthstart(today(),3)

Channa