Set max current selections displayed with GETFIELDSELECTIONS()

[#1]

Hi,

I am using QlikView and have a textbox that displays selections made in a field using the GETFIELDSELECTIONS function. However once I select over 6 items in that field, instead of displaying each item the textbox displays '7 of 58'.

I have gone into user settings and changed the limit in Max Values in Current Selections, and this changes the number of items that are displayed in a Current Selections Box before showing 'X of 58'.

Is there a way I can change the limit for text boxes and GETFIELDSELECTIONS()? Or is there another way to do this?

Thank you for any help.

[Gysbert_Wassenaar · Accepted solution]

In charts and textboxes you use the GetFieldSelections function where you can pass more parameters besides the field name to the function. The last parameter determines how many results are shown before it switches to X of Y. See the help for more online information: GetFieldSelections ‒ QlikView

[#3]

I forgot to specify that changing the limit in Max Values in Current Selections only changed the number of items shown in the Current Selections box and not the textbox.

Thanks.

[#4]

Thank you very much Gysbert!