cancel
Showing results for 
Search instead for 
Did you mean: 

Ordering of filter

Former Member
0 Kudos

Hi all,

I'm trying to create a filter for year, showing the actual year at startup. However, the filter component seems to sort ascending. There is no sort option or "initial value" option.

Any ideas?

Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

arijit_das
Active Contributor
0 Kudos

Instead of Filter component, you can use Combo Box component which takes the order of labels as it is in the excel model (not sorted automatically). Also, there is option to specify a default selection after initialization.

To get a cascaded filtering experience with combobox, please go through the blog:

Former Member
0 Kudos

ComboBox - very powerful compared to the filter (when not using WebI).

Thanks for your help!

Answers (2)

Answers (2)

former_member190855
Active Contributor
0 Kudos

Hi Andreas

The best way to sort the data will be to sort it at the source - 1) if you are using Query Browser then there is a sort feature right in the query definition. You should sort the data and bind the filterto the query or to the spreadsheet area where data is coming

2) If your data source is different, try to sort it at the WebI/universe it self.

Next option is to write formula in excel to sort it (bad for performance )

You can refer to the attached xlf for formula.

Also, as Arijit suggested, use Combo Box instead of the filter component.

For Initial Value option > Go to behavior tab of the combo box > Common > Selected Item > Type Label > Label = bind to the cell which will contain your initial value.

Runali

Former Member
0 Kudos

Are you creating a webi ? as there is not initial filter option in dashboard.. All the filtering happens in runtime.. If its webi ..There is actually an option for set default value which will store the default value.. check the screenshot below..

However if you want to change the sort order then the only option you have is to use a parameter from universe with custom LOV..

If you are using dashboard and just looking to order of  LOV in a combo box or any other type of selection component then you will have to retrieve the value from database and bind it to the spreadsheet in the order you want to achieve the proper ordering.. You can also achieve default value easily in dashboard..

Former Member
0 Kudos

Thanks, but no WebI, just the Excel sheet...