Skip to Content
author's profile photo Former Member
Former Member

Ordering of filter

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 02, 2014 at 07:08 PM

    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: Filtering Through Combo Box

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 08:05 PM

    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


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 06:22 PM

    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..


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.