topic Labels for qualified fields in QlikView

Labels for qualified fields

Wed, 03 Dec 2014 15:20:03 GMT

Hi all,

I have a QlikView document in which I have multiple qualified tables. In the front-end I created a number of table boxes which contain the content of those qualified tables. Now I would like to get rid of the qualified without renaming the labels one-by-one. Is there a simple way to do this?

So table contains:

Table1.Field1, Table1.Field2, Table1.Field3

And labels need to be:

Field1, Field2, Field 3

Please help! Thanks.

Re: Labels for qualified fields

JonnyPoole — Wed, 03 Dec 2014 15:25:01 GMT

You can rename using a mapping table.

For example, here the mapping table has a list of old (ie: current) field names, and the new names are the 2nd column. The rename fields using fieldmap auto renames all the fields using the map.

FieldMap:

MAPPING

LOAD

oldnames,

newnames

FROM <fieldmappings>

RENAME Fields using FieldMap;

Do you need to figure out all the fields that need renaming dynamically ? or do you have a list you can create through an inline table or spreadsheet ?

Re: Labels for qualified fields

Wed, 03 Dec 2014 15:38:10 GMT

Hi Jonathan,

Thanks for your swift response. Unfortunately just renaming the fields would mess up my data model since it contains a lot of similar fields. Do you have an other solution?

Re: Labels for qualified fields

JonnyPoole — Wed, 03 Dec 2014 16:17:31 GMT

I don't, use you could the mapping table to 'fetch' the label but it still means putting in the right expression in each 'label' in the table box.