Selecting Date range in Date picker from last 30 days till today

[aatish12345]

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

[EliGohar]

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.

[aatish12345]

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

[EliGohar · Accepted solution]

Try this expression please:

= '>=' & Date(Today()-30) & '<=' & Date(Today())

Eli.

[aatish12345]

Hi Eli,

Yes, now it is working as expected..

Thanks you very much for this ☺️

Aatish

[harithadogiparthi505]

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.