Store Date from Date Filter and Update table based on the selected date

[msapre]

I have a date filter, which looks like this.

I want to make it so that when the user selects a date, a table further down updates.

The value par is just the variable par. I want to store the selected date, and display the par variable in a table for the last 2 quarters before the selected date, sorted by investors with the highest par value on the selected date. How would I achieve this?

[nevopotokcloudinary]

Hi,

What I usually do is storing the selected date as vMaxDate (variable) and then another variable when I subtracting x days and then get two dates which I use them in my set analysis.

[Anil_Babu_Samineni]

how is your expression looks like? IMO - I could do like this

Sum({<DateField = {">=$(=Date(AddMonths(DateField, -6)))<=$(=Date(Max(DateField)))"}>} Investors)

[nevopotokcloudinary · Accepted solution]

Hi

since I'm using variable so my expression contains the varialbles instead

e.g.

vMaxDate = Max(DateField)

vMinDate = Date(AddMonths(Max(DateField),-6))

Sum({<DateField = {">=$(vMaxDate)<=$(vMinDate)"}>} Investors)

There are main two reason that I rather use variables:

1.reuse of the same code and function in many places and reduce the chances to mistakes.

2.Variable only calc once while in complex app that contains many calc I rather to minimize the number of calculation so the UI will work smooth as possible

[msapre]

Thanks! This worked for my charts.