Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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