topic Re: Not able to get all selected fields in QlikView

Not able to get all selected fields

ferha_jafri — Thu, 09 Jul 2015 09:44:33 GMT

Hello Everyone,

In this expression Concat(GetFieldSelections(Work)) I am not able to understand why this is not getting all selected values as when the selection increased 6 selections it is showing Not and then later selections and if all selctions are selected it is showing ALL , not sure whether any other function should be used.

Thank You

Ferha

Re: Not able to get all selected fields

sunny_talwar — Thu, 09 Jul 2015 09:49:31 GMT

Try this:

=GetFieldSelections(Work, ',', 9999)

Update:
here ',' is the seperater between each selected value and 9999 is telling the expression to show 9999 different values instead of showing ALL after the selection exceeds a certain count.

HTH

Best,

Sunny

Re: Not able to get all selected fields

avinashelite — Thu, 09 Jul 2015 09:50:34 GMT

Hi Ferha,

As per my understanding, your trying to display the selection of the field in text box?? if you when you are selecting more values , may be due to the space constraint its showing like that....try like:

Concat(GetFieldSelections(Work),'&')

can you please share the what you getting and what the issue

Re: Not able to get all selected fields

ferha_jafri — Thu, 09 Jul 2015 10:07:49 GMT

Thank You so much it is working....

Re: Not able to get all selected fields

sasiparupudi1 — Thu, 09 Jul 2015 10:08:27 GMT

Please try

Concat(GetFieldSelections(key,',',GetSelectedCount(key)))

Re: Not able to get all selected fields

sunny_talwar — Thu, 09 Jul 2015 10:14:23 GMT

Awesome

I am glad I was able to help.

If you got your answer I would suggest marking correct answer as well as any helpful answers

Best,

Sunny