A string of field names as 1 field without using an inline

[helen_pip]

Dear Qlikview user

I was wondering if it is possible to create a string of field names within the load script of a table without using an inline statement

In the table below, the fields are loaded in, but I would also like to concatenate the field names so I have a list box from that derived field

Table

Dim_OP

Load

Division,

Care_Group,

Treatment_Function

FROM Table1

I would like to add a field to the above table, so that the list Box gives me the following desired results

ListBox

Division

Care_Group

Treatment_Function

Could anyone, kindly help me achieve this

Kind Regards

Helen

[marcus_sommer]

This is already included within qlik. You could use the system-fields $Table and $Field to get a listing of the available tables and fields and there is also an included object "structure table" (or similar translated) - by right clicking on the sheet and choosing new object is it the last one.

- Marcus

[helen_pip]

Hello Marcus

Thank you for your help

Is there anyway I can configure list box to look at the $Field to just look at a couple of fields I.e. Just Division and Care_Group, as I have numerous fields available to me

Any help is greatly appreciated

Thanks

Helen

[marcus_sommer · Accepted solution]

You could use a listbox-expression like:

if($Table = 'Dim_OP', $Field)

and maybe some more if-loops or a match($Field, 'Division', 'Care_Group', 'Treatment_Function') condition.

- Marcus

[helen_pip]

Thanks Marcus

You have helped me achieve my desired results

With your help I can get a list of the field names

=Pick(match($Field, 'Division', 'Care_Group'), 'Division', 'Care_Group')

Kind Regards

Helen