Concatenate TableName with associated FieldName using GetFieldSelections

Tue, 18 Apr 2017 09:57:53 GMT

Hi Folks,

I use Text Object and I am trying to concatenate Tablename with Fieldname using GetFieldSelections().

For example, TableA has a1,a2,a3,a4 fields. TableB has b1,b2,b3 fields. TableC has c1,c2,c3 fields.

When I select fields a1,b2,c3 which are in different list boxes, it shows TableA,TableB,TableC/a1,b2,c3 in Text Object if I use =GetFieldSelections(%TableName)&'/'&GetFieldSelections($Field) or concat(GetFieldSelections(%TableName)&'/'&GetFieldSelections($Field)) or concat() or =concat(GetFieldSelections(%TableName))&'/'&concat((GetFieldSelections(%FieldName)))

But I need to see TableA/a1,TableB/b2,TableC/c3.

Could you please help me with this.

Note:I can use concat($TableName&'/'&$Field) to get result but the performance is dead slow on user selections.

Thanks

topic Concatenate TableName with associated FieldName using GetFieldSelections in QlikView

Concatenate TableName with associated FieldName using GetFieldSelections