Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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