Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

Dateselect Current period

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

Labels (2)
4 Replies
vinieme12
Champion III
Champion III

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

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
johnan
Creator III
Creator III
Author

Hi, thanx 🙂

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

 

johnan
Creator III
Creator III
Author

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_0-1652877131806.png

 

johnan
Creator III
Creator III
Author

Found a solution 🙂