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

Make expression Date(FirstSortedValue(Date, -Aggr(Max({}Value),Value) choosable

Mon, 01 Jul 2013 14:53:19 GMT

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?

Re: Make expression Date(FirstSortedValue(Date, -Aggr(Max({}Value),Value) choosable

Mon, 01 Jul 2013 15:10:16 GMT

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.

Re: Make expression Date(FirstSortedValue(Date, -Aggr(Max({}Value),Value) choosable

Mon, 01 Jul 2013 15:25:09 GMT

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:)