How to set a date dimension to specific date range - Qlik Community

krissy_s · ‎2019-05-26

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.

lironbaram · ‎2019-05-27

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

Channa · ‎2019-05-27

=monthstart(today(),3)

Channa