
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selecting Date range in Date picker from last 30 days till today
Hi All.. When user accessing a sheet with sheet name let's say 'Sheet1" in Qliksense then I want to show last 30 days to be selected from today's date by default in Date range picker...
Can anyone plz help me out with this?
Aatish
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this expression please:
= '>=' & Date(Today()-30) & '<=' & Date(Today())
Eli.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using Actions (in sheet properties):
1. select action - Select values matching search criteria
2. Choose your date field
3. Set the following expression: ='>=' & Date(Today()-30)
When you'll open the sheet it will automatically select the last 30 days.
Eli.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Eli,
Thanks for your valuable help..
The solution you've provided is selecting values from last 30 days till future dates also, since I have some future dates as well in date field..
I was looking for a solution which will select values from last 30 days till Today only...that means range of 30 days from last 30 days till today's date
Aatish

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this expression please:
= '>=' & Date(Today()-30) & '<=' & Date(Today())
Eli.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Eli,
Yes, now it is working as expected..
Thanks you very much for this ☺️
Aatish

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi EliGohar,
I have used the similar expression to select the default date range.
The problem which I have encountered during my process is :
I have 4 sheets in my dashboard, first sheet is showing default range and when entered into second sheet its good showing def range and when coming back to first sheet again its showing automatically previous week of default range. Is there any alternate solution?
Please suggest me the solution .
Thanks in advance.
