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

      Hallo,

       

      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?