topic Re: Set max current selections displayed with GETFIELDSELECTIONS() in QlikView

Set max current selections displayed with GETFIELDSELECTIONS()

Thu, 09 Feb 2017 17:42:49 GMT

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.

Re: Set max current selections displayed with GETFIELDSELECTIONS()

Gysbert_Wassenaar — Thu, 09 Feb 2017 17:47:33 GMT

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

Re: Set max current selections displayed with GETFIELDSELECTIONS()

Thu, 09 Feb 2017 17:47:59 GMT

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.

Re: Set max current selections displayed with GETFIELDSELECTIONS()

Thu, 09 Feb 2017 17:55:13 GMT

Thank you very much Gysbert!