Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date in table only is displayed after select - firstSortedValue

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

0 Replies