How to Display associate values in Text Box

[#1]

Hi All,

Please find the below screenshot.

I have a list if fields like the above, when I select " sbutypename" it will be display in the text box. the four value which are showing in the activityid 327,328,329,331 are the associate value for the current selection.

With out selecting" activityid" value how can I display in the List box. Is it possible in Qlikview or not?

I used GetFieldselection(sbutypename,',') for the "text objects".

Please help me.

Thanks.

[sunny_talwar]

Have you tried GetFieldSelections() for activityid also?

=GetFieldSelections(activityid, ', ')

or

=Concat(Distinct activityid, ', ')

[sunny_talwar]

[PrashantSangle]

Hi,

GetFieldSelection() work only if you select in field

Concat() will definately work.

Regards

[sunny_talwar]

Good catch

Sorry for the misleading information

Best,

Sunny

[#6]

Hi Sunny,

Thank you for your help,

=Concat(Distinct activityid,',) is working.

I tried "=GetFieldSelections(activityid,',') ", when I selected any value in the activityid list then only it will display otherwise it will be blank.

A small change, if I use =Concat(Distinct activityid,',) in activityid all values are displaying default

is there any way when I select a particular value in sbutypename then only activityid will be display otherwise it will be blank.

Thanks.

[tresesco]

And concat() would not work if only the selection has to be considered.

[sunny_talwar · Accepted solution]

You can try this:

=If(GetSelectedCount(sbutypename) > 0, Concat(Distinct activityid,',))

[jagan]

Hi,

Try

=Concat(DISTINCT activityid , ',')

Hope this helps you.

Regards,

Jagan.

[Digvijay_Singh]

You can try like this -

=Concat({<Product=P(Product)>}Product,',')