Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Saving any selections information of any field in a variable

Hi ,

I want to capture the selection of a user of any field in the dashboard ,so far i have the below script which gives me selection info for any fields
=GetCurrentSelections($Field)

The problem with this is that if a user selections more than 5 values then  it does not show me the list of selected values

Any ideas how can i capture selection info similar to what is shown in Current Selection Box .

Regards ,

Tushar

2 Replies
krishna_2644
Valued Contributor III

Re: Saving any selections information of any field in a variable

try :

vVariable = concat(GetCurrentSelections(),'|').

This stores all the current selections in the format :  field : x | Y | z....

MVP
MVP

Re: Saving any selections information of any field in a variable

I think you have to use the bold parameter


this is from QlikView help

getfieldselections ( FieldName [, ValueSep [, MaxValues [, State]]])

Returns a string with the current selections in a field. It is possible to query an alternate state.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Community Browser