Discussion board where members can get started with QlikView.
I have a filter and want to show selected values of LETTER in a text box.
If I omit some of the values of LETTER, it is showing like LETTER : NOT A, B, D, C, N with GetCurrentSelections.
I want to show all the selected values in text box.
How to achieve this?
Go to Solution.
=GetFieldSelections(LETTER, ',', 1000)
To understand read (From 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.
State is the alternate state to query.
The string that is returned can be in these forms:
=GetFieldSelections(LETTER, ', ', 26)
You can see more examples here:
Missing Manual - GetFieldSelections() + Bonus Example
May be this expression will be work,
=Concat( LETTER &Chr(10) )
You can also try this,
=Concat( LETTER &Chr(2) )