Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Date range expression in default selection bookmark

Hi guys,

I am trying to create a bookmark for default selection when the app opens. I'm using the following expression for my date field which is called [Transaktion Dato]:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1)

Screenshot 2020-05-06 at 12.11.47.png

I have a filter pane in my sheet where I can enter the above expression in the filter part. Above expression works as expected but I am trying to change expression to have an upper bound on the dates as well. The following is not working for me:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1)<Date(Today(1)-1)

I want to limit the selection to the last 30/31 days excluding today as well.

Can anyone tell me how to do this correctly?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Date range expression in default selection bookmark

Try like:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1) And [Transaktion Dato]<Date(Today(1)-1)

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Date range expression in default selection bookmark

Try like:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1) And [Transaktion Dato]<Date(Today(1)-1)

View solution in original post

Highlighted
Partner
Partner

Re: Date range expression in default selection bookmark

you filter expression looks good.

what is your actual result?

Highlighted
Partner
Partner

Re: Date range expression in default selection bookmark

Thanks, this is exactly what I needed.