topic Re: GetFieldSelections() function's return after wild card search was used in QlikView

GetFieldSelections() function's return after wild card search was used

vlad_komarov — Mon, 15 Sep 2014 18:08:11 GMT

Hello,

In my application I am using a string that is generated by GetFieldSelections() function.

It works fine if I am selecting items in the list box directly.

I've noticed that if I am using the wild card search and pressing Enter, than all desired items are displayed selected, but the GetFieldSelections() function returns just an entered search string:

Clicking on any of selected items, or adding new item to selected list resets the GetFieldSelections() string to desired value:

Any suggestions how to achieve it with just using the wildcard search option?

Best regards,

Vladimir

Re: GetFieldSelections() function's return after wild card search was used

JonnyPoole — Mon, 15 Sep 2014 18:21:58 GMT

i would suggest using concat (distinct <fieldname>) to bring back a pipe delimitted list of unique selected values;

ex: = concat( DISTINCT Year, '|')

Re: GetFieldSelections() function's return after wild card search was used

vlad_komarov — Mon, 15 Sep 2014 18:43:45 GMT

Jonathan,

Thanks for suggestion.

Yes, it works, but I am keeping this option as a last resort due to performance issues with using concat().

Plus I have to separately handle the case when no items are selected, which is adding more burden on app's performance.

Vladimir

Re: GetFieldSelections() function's return after wild card search was used

JonnyPoole — Mon, 15 Sep 2014 18:50:38 GMT

Ok thanks. Just in case you were not aware if none are selected you can capture that situation with this expression:

if ( getselectedcount( Values) = 0 , ....

to invoke the calculation conditionally. getpossiblecount( Values) can also be handy in these situations to figure out the count when other fields have selections and some Values are in white and others in grey.

Re: GetFieldSelections() function's return after wild card search was used

vlad_komarov — Mon, 15 Sep 2014 19:33:39 GMT

Yes, it's pretty much how I am doing that.