Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to force consistent output from GetFieldSelections

Hello,

The following script creates a list from 1 to 10

  [selection]:

  LOAD

    RowNo()    as no

  AutoGenerate (10);

I created a variable to hold the selectio(s) from this list

  vSelected = GetFieldSelections(no, ',')

When I select 1 to 6, vSelected = 1,2,3,4,5,6

When I select 1 to 7, vSelected = NOT 8,9,10

When I select 1 to 10, vSelected = All

This is correct but gives me problems when I use the Index() function.

Is there a possiblility to always get a list of the selected numbers ?

Auke

1 Solution

Accepted Solutions
Not applicable
Author

Sorry, case of RTFM.

  GetFieldSelections(fieldname [, valuesep [, maxvalues=6]])

View solution in original post

1 Reply
Not applicable
Author

Sorry, case of RTFM.

  GetFieldSelections(fieldname [, valuesep [, maxvalues=6]])