Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
shinnickr
Creator II
Creator II

Set a variable to include everything up to yesterday's date.

Hi,

I am hoping to set a variable to include every day up to yesterday.  My field starts in 2012 and I want to include every day from 2012 -  yesterday.  I have a variable for yesterdays date 'Date(Today() -1)' but I want to include everything up to and including that date.  I don't know if I'll need some set analysis or if there's a function that would help me with that so I would appreciate any help that can be given.

Thank you very much.

42 Replies
sunny_talwar

Here are some ideas

Capture.PNG

shinnickr
Creator II
Creator II
Author

Oh I like the textbox showing the range, that is a great idea.  I appreciate it!  Thanks Sunny, you're the best! 😃

shinnickr
Creator II
Creator II
Author

Thanks Irene!  I truly appreciate the help.  I did end up finding a way to do what I wanted, courtesy of Sunny.  I'm using ='=[Service Date] < Today()' and it is accomplishing what I was looking to do.

Unfortunately, in my current selections box it shows the formula Current Selections.PNG and it could be confusing to the end user.  I've looked at a couple different solutions but don't have anything too great.  If you have any ideas on how to change the displayed formula I'd love to take a look!