Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selected values

Hi All,

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?

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=GetFieldSelections(LETTER, ',', 1000)


Capture.PNG

View solution in original post

5 Replies
sunny_talwar

Try this:

=GetFieldSelections(LETTER, ',', 1000)


Capture.PNG

View solution in original post

tresesco
MVP
MVP

=GetFieldSelections(LETTER,',',100)

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:

  

'x, y,z'If the number of selected values is Maxvalues or less, the string returned is a list of the selected values, separated with Valuesep as delimiter.
'NOT x, y, z'If the number of non-selected values is Maxvalues or less, the string returned is a list of the non-selected values, separated with ValueSep as delimiter, and NOT as a prefix.
shun_wong
Partner
Partner

Hi Jack,

Try using

=GetFieldSelections(LETTER, ', ', 26)

You can see more examples here:

Missing Manual - GetFieldSelections() + Bonus Example

Shun

susovan
Partner
Partner

Hi,

May be this expression will be work,

=Concat( LETTER &Chr(10) )

Warm Regards,
Susovan
susovan
Partner
Partner

Hi Jack,

You can also try this,

=Concat( LETTER &Chr(2) )

Warm Regards,
Susovan