2 Replies Latest reply: Jul 1, 2013 11:25 AM by sarah_mader RSS

    Make expression Date(FirstSortedValue(Date, -Aggr(Max({<Date={'<=$(currentDate)'}>}Value),Value) choosable



      i have a table chart with following dimensions/expressions:



      Dimension:         Serial_No

      Expression:        Max({<Date={'<=$(currentDate)'}>}Value) 

                               Date(FirstSortedValue(Date, -Aggr(Max({<Date={'<=$(currentDate)'}>}Value),Value)


      All is working fine, but i want to know if there is a possibility to make it choosable, means if i click it, i want the special Day to be choosen in Field 'Date'...


      Does QV supports this?