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

[#1]

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?

[#2]

Why don't you add a multibox that a allows to select only one value in the Field 'Date'?

You won't be able to add the functionality you want directly in the table chart... unless you add the Field Date as a Dimension and enable the DropDown select for that dimension.

[#3]

Sure, there are many other ways to select:)

But i only want to know if its possible...

It's much easier just to click at the row u want;)

Anyway thank u:)