topic multiple records in a text box in QlikView

multiple records in a text box

Fri, 21 Jun 2013 11:10:32 GMT

Hi,

I need to display multiple records from a field in a text box objext, i.e. multiple product codes.

Is there a function I can use for this e.g. concatenate function?

At the moment, if there is an attribute found for two product codes, only the first one displays.

Regards,

Gregg

Re: multiple records in a text box

rustyfishbones — Mon, 01 Jul 2013 20:51:45 GMT

Hi Gregg,

Did you try add a Text Object and try

=GetCurrentSelections([Product Code])

This will result in a Text Object saying

Product Code: A001, B001, C001 ETC.....

You can add SUBFIELD to it to clear Product Code:

=SUBFIELD(GetCurrentSelections([Product Code]),':',2)

result is A001, B001, C001

Does that help

Regards

Alan

Re: multiple records in a text box

Tue, 02 Jul 2013 22:03:04 GMT

Hi Al,

I got this working using the concatenation function.

The user enters in different criteria so if there are multiple records found, I use the concatenation distinct function to effectively list them all out.

Regards,

Gregg