Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

How to structure a lot of fields

Hi.

I need to load a lot of fields (more than 400) from different dimensions, and I have the following questions:

1) is there a way (easy, remember there is 400 fields) to show the labels insted of (or maybe together with) the fieldname (the data is read from a SQL database)

2) is it possible to structure the fields so the user of the app can see a "grouping" of the fields by the dimension they are from instead of the normal alphabetic order of all the fields loaded.

Thanks in advance

Best regards

Brian

Labels (3)
1 Solution

Accepted Solutions
Jacek
Contributor

Re: How to structure a lot of fields

Hi,

you can use mapping table (stored in Excel) for technical and business name of fields + use RENAME function during reload script.

Please follow links:

Rename fields - Qlik Help 

How to Rename Fields using Mapping Table

How to rename a field in qlikview

 Your second question - you can use QUALIFY function for that, then Qlik will add prefix (source table name) to the name of field or develope with TAG function: HELP LINK

hope it helps

2 Replies
Jacek
Contributor

Re: How to structure a lot of fields

Hi,

you can use mapping table (stored in Excel) for technical and business name of fields + use RENAME function during reload script.

Please follow links:

Rename fields - Qlik Help 

How to Rename Fields using Mapping Table

How to rename a field in qlikview

 Your second question - you can use QUALIFY function for that, then Qlik will add prefix (source table name) to the name of field or develope with TAG function: HELP LINK

hope it helps

Partner
Partner

Re: How to structure a lot of fields

Hi Jacek.

Great, thanks for your help and a very quick response.