on 01-02-2014 6:11 PM
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!
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.