0 Replies Latest reply: Jul 30, 2013 11:51 AM by Fabian Heidenstecker RSS

    Getfieldselections() order

    Fabian Heidenstecker

      Hello,

       

      can anybody explain to me how QlikView deals with the selection order?

       

      I want to build a qlikview tab with a listbox. This tab should contain 4 charts and some listbox. The user can make selections in the listboxes.

      The charts calculate based on selections that are made in a certain listbox (Country). So when the user selects 4 countries, the charts should build up in the order the user has made his selections.

      I can't get this order figured out!

       

      I used a variable that holds the following function

      Trim(TextBetween(',' & GetFieldSelections($1) & ',', ',', ',', $2))

       

      I call that variable in a set analsys formula, with the number of the selected item as a parameter

      sum({<Country={$(=$(GetFieldSelection(Country,1)))}>} Sales)

       

      When i set the fields sort order to alphabetical it works, but like it said, if a call this function with the parameter 3 it should display the country i selected as third, but not the third country in alphabetical order....

       

      Any Ideas?

       

      Thanks,

      Fabian