Dynamic date

[JRamos]

Hi all,

I'm just moving to QlikSense from Tableau but I need to create a "dynamic date/parameter date", I'm using my date like a filter but I need to show the data from the last date of my date filter selection for only one of my columns, for example:

Date Filter       The one column      All the other data

09/28/21          09/27/21                     09/28/21 

09/29/21          09/28/21                     09/29/21 

09/30/21          09/29/21                     09/30/21 

Is that possible? Could you support me?

Regards!!!

[JRamos]

Maybe I'm forgetting a ")", but the set analysis shows an error 

[JRamos]

I modified the expression to: count( {< [date_search] = {'$(=date(max([date_search]) - 1))'}>}[value_calculate]) and now it's working!

Thank you so much @stevejoyce !!!

Best regards!

[SudharsaanJ]

What is the purpose of the dollar & equals sign within the sum( {< [My date filter] = {'$(=date(max([My date filter]) - 1)'} >} sales) set analysis expression? Does it cause the date function to become a dynamic function? Also, what resources did you use to learn about these expressions? Thanks.