Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Set max current selections displayed with GETFIELDSELECTIONS()

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set max current selections displayed with GETFIELDSELECTIONS()

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Re: Set max current selections displayed with GETFIELDSELECTIONS()

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


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: Set max current selections displayed with GETFIELDSELECTIONS()

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.

Not applicable

Re: Set max current selections displayed with GETFIELDSELECTIONS()

Thank you very much Gysbert!