Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krissy_s
Contributor III
Contributor III

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
lironbaram
Partner - Master III
Partner - Master III

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
Specialist III
Specialist III

=monthstart(today(),3)

Channa