Qlik Community

New to Qlik Sense

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rasmusnielsen
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?

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

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

View solution in original post

agigliotti
Partner
Partner

you filter expression looks good.

what is your actual result?

rasmusnielsen
Partner
Partner
Author

Thanks, this is exactly what I needed.