Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

how to sort data in dropdown list in text area


priyanka patil 2

Recommended Posts

input :[FY19-P01,FY19-P02,FY19-P04,FY19-P03,FY19-SY-P07,FY-SY-P10,FY-SY-P09,FY20-FEB,FY20-APR,FY20-JAN,FY20-MAR]

output:[FY19-P01,FY19-P02,FY19-P03,FY19-P04,FY19-SY-P07,FY-SY-P09,FY-SY-P10,FY20-JAN,FY20-FEB,FY20-MAR,FY20-APR]

in future if data increase it should be able to sort exmaple Fy21-JAN,Fy21-FEb

Link to comment
Share on other sites

Spotfire automatically sorts filters in asceding order - it is doing so in this case as well - but the result is not as intended because the data is in form of a string rather than date/month.

So for the filter to be in date wise ascending order you will have to process that column and bring it to one of the supported date formats

Ex: "FY20-Jan" -> "2020 - Jan"

Link to comment
Share on other sites

×
×
  • Create New...