Dateselect Current period

[johnan]

Hi,

I have 6 post with diffrent values. There is a date like this:

FromDate	Value
2025-08-03	224
2024-08-03	403,2
2023-08-03	582,4
2022-08-03	761,6
2021-08-03	940,8
2020-08-03	1120

I just want to show 2021-08-03 because it's current value (940,8) to show according to the date today.. When the date is =>2022-08-03 then i want the new value to show (761,6) What the best solution for this?

Br

[vinieme12]

As below

Sum({<Date={">=$(=Date(yearstart(today()),'YYYY-MM-DD'))<=$(=Date(yearend(today()),'YYYY-MM-DD'))"}>}

Value)

Refer this article

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

[johnan]

Hi, thanx 🙂

Can i do this in Script? I want to filter all the others value 🙂

[johnan]

Hi again, i try this, but it gives me wrong value.
It should be 2021-08-03, because 2022-08-03 have not passed yet

I used this:
Sum({<FromDate={">=$(=Date(yearstart(today()),'YYYY-MM-DD'))<=$(=Date(yearend(today()),'YYYY-MM-DD'))"}>}Value)

But the best way is to hide the other values already in script i think?

[johnan]

Found a solution 🙂