Discussion board where members can get started with Qlik Sense.
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
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
View solution in original post
Great, thanks for your help and a very quick response.