Spotfire: Sort a dropdown list to the max date by default

[Xav Dou]

Hi,

I created a dropdown list in the text area with a datecolumn.

This list allows me to filter a table with the same datecolumn.When i choose a date in the dropdown list, it shows the value with the same date in the table.

I would like the max date to be shown by default on the table to the users.

I can do it directly on the table (either by using limit date expression with datetimenow or by using show/hide items but then the user cannot choose another date by clicking on the dropdown list...)

I think the solution is toapply the max date by default on the dropdown list.

Any idea how to do that

[Khushboo Rabadia]

You can use javascript or data function to set dropdown list value to Max date value on load of analysis which will ultimately set Max date value filter so table visualization will show Max date values.

Please check the below KB:

https://support.tibco.com/s/article/How-to-automatically-set-a-property-value-to-the-current-date-time-with-a-Text-Area-JavaScript

https://support.tibco.com/s/article/How-to-execute-an-Iron-Python-script-on-loading-of-a-cached-analysis-in-TIBCO-Spotfire-Web-Player

[Xav Dou]

Thank you for the help @Khushboo. I tried the javascript solution. I get today's date automatically: 11/03/2020

 

But when i want to apply it to the table where is my date column ("HistoryDatetime") by using the limit data expression, i get the error "the property "11/03/2020" does not exist." (see attachment)

 

Is it because in the javascript, it is only for string data type "

 

"step 8. In the "New Property" dialog's "Data type" drop-down list, ensure that the "String" data type has been selected."

 

Any idea how to solve that