Getfieldselections() order

fheidenstecker — Tue, 30 Jul 2013 15:51:09 GMT

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

topic Getfieldselections() order in QlikView

Getfieldselections() order