Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
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:
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
Hi Jacek.
Great, thanks for your help and a very quick response.