Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
how is your expression looks like? IMO - I could do like this
Sum({<DateField = {">=$(=Date(AddMonths(DateField, -6)))<=$(=Date(Max(DateField)))"}>} Investors)
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
Thanks! This worked for my charts.