Date in table only is displayed after select - firstSortedValue

Wed, 07 Aug 2013 13:56:40 GMT

Hallo!

I'm wondering about my firstSortedValue function...

In my Project i have a table chart with following Dimensions and Expressions:

Dimension:

- SERIAL_NO

Expressions:

- Max({<Date={'<=$(currentDate)'}>}Value_Amount)

-> Seems to work fine

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

-> for some values directly shown, for others i have to select a SERIAL_NO

- Avg({<Date={'<=$(currentDate)'}>}Value_Amount)

-> Seems to work also fine

To make this more clear, some screenshots.

Sry for censored fields, but i rly cant share the project^^

Without Selection, the table chart look like NoSelect.png and after select like selected.png...

The funny is, the Date is correct^^ But why only after select?

Thanks for any help:)

Greetings
Sarah

topic Date in table only is displayed after select - firstSortedValue in QlikView