How to restrict the date values

RealEstate2018 — Sat, 16 Nov 2024 02:31:10 GMT

Hi team,

Can someone please help restrict my data value so that my bar chart doesn't display data before today's date? I want to display all data from today's date until the next 5 years. Shown below is the expression I have put into the script. Do I need to modify it or put something into the dimension limits? It works just fine however, it's displaying one location that has an expiration date of 9/14/17 (well before today's date)

only({<Year = {"<=$(=max(year(today())) + 5)"}>} Expiration)

Re: How to restrict the date values

Vegar — Tue, 10 Sep 2019 18:33:00 GMT

You need to define both a min year and a max year.

only({<Year = {">=$(=year(today()))<=$(=year(today()) + 5)"}>} Expiration)

You don't need the max() as you only have one value inside it, today().

topic Re: How to restrict the date values in QlikView

How to restrict the date values

Re: How to restrict the date values