topic Re: Show one value in Text Object, when Multiple selection from List Box in QlikView

Show one value in Text Object, when Multiple selection from List Box

dmohanty — Fri, 24 Apr 2015 01:49:01 GMT

Hi All,

Suppose I have a List Box with values - A, B, C, D, E.

I have another Text Object, where I have to display a value from a List Box when selected from List Box. - THAT IS WORKING.

But my requirement is - When I select more than one value from List Box, only and any one (from selected) will be displayed in the Text Object.

How to achieve this? Please help!!!

Re: Show one value in Text Object, when Multiple selection from List Box

Fri, 24 Apr 2015 02:44:32 GMT

Hi ,

in Text object use

=getFieldSelections(nameofthefield).

Hope this helps

Re: Show one value in Text Object, when Multiple selection from List Box

ramoncova06 — Fri, 24 Apr 2015 02:59:20 GMT

=subfield(GetFieldSelections(field,'||'),'||',1)

Re: Show one value in Text Object, when Multiple selection from List Box

dmohanty — Fri, 24 Apr 2015 04:03:30 GMT

This won't work when we select multiple values.

Re: Show one value in Text Object, when Multiple selection from List Box

sujeetsingh — Fri, 24 Apr 2015 04:18:52 GMT

Get field selection will work as per your need. You can have a sorting field and apply it to just show the sorted value of multiple selection .

Re: Show one value in Text Object, when Multiple selection from List Box

amit_saini — Fri, 24 Apr 2015 04:20:06 GMT

Hi ,

Try this:

='Chart'&chr(32)&if(GetSelectedCount(Plant)>0,'- '&GetFieldSelections(Plant))

Thanks,

Re: Show one value in Text Object, when Multiple selection from List Box

Fri, 24 Apr 2015 04:21:49 GMT

Hi try

GetFieldSelections(field,',')

GetFieldSelections(field,',',n)

where n is any integer denoting how many selected values to display with ','

check out this document

Missing Manual - GetFieldSelections() + Bonus Example

Re: Show one value in Text Object, when Multiple selection from List Box

ramoncova06 — Fri, 24 Apr 2015 04:26:54 GMT

‌my codes does work, no need to sort or add complex things to it

Re: Show one value in Text Object, when Multiple selection from List Box

PrashantSangle — Fri, 24 Apr 2015 05:18:02 GMT

Hi,

Use more simpler

Concat(FieldName,',')

Regards

Re: Show one value in Text Object, when Multiple selection from List Box

Anonymous — Fri, 24 Apr 2015 05:28:42 GMT

use this - it will give you only one value from the list.

SubField(Concat([Fieldname],'@'),'@',1)

Thanks

BKC

Re: Show one value in Text Object, when Multiple selection from List Box

sunilkumarqv — Fri, 24 Apr 2015 05:29:16 GMT

@HI DMohanty

try this

=SubField(GetFieldSelections(ID,','),',',1)

Re: Show one value in Text Object, when Multiple selection from List Box

jagan — Fri, 24 Apr 2015 07:36:18 GMT

Hi,

To display selected multiple values you can use GetFieldSelections(FieldName, ',').

If you want to display only one value use

=MaxString()

MinString().

Regards,

Jagan.

Re: Show one value in Text Object, when Multiple selection from List Box

ankitaag — Fri, 24 Apr 2015 09:06:06 GMT

Hi,

Please see the screenshot