topic Re: Replacing Database names in search object etc. in QlikView

Replacing Database names in search object etc.

shyamcharan — Fri, 09 Jan 2015 04:56:37 GMT

Hi Experts,

I have used standard database table and column names in Qlikview Dashboards.

I have used Qualify ; function throught so that the names are consistent throught(DB, QVD, Datamodel and Dashboards)

However this is a problem. Using these names(Table.Column) in the search objects and other objects in the dashboard are not user friendly for obvious reasons like they are technical.

Now can i smartly change the names of these fields to show a user friendly name. Can I do something at the dashboard side?

Thanks in advance for your help.

Regards,

Shyam.

Re: Replacing Database names in search object etc.

ecolomer — Fri, 09 Jan 2015 05:32:49 GMT

You can use "as" sentence to change the name of fields in script

Re: Replacing Database names in search object etc.

shyamcharan — Fri, 09 Jan 2015 05:38:52 GMT

Thanks for the inputs Enrique.

But in my case I am using a datamodel and If had to change there are around 300 fields that I need to change in the script.

However, the search object do have only a few fields that need to be displayed with a user friendly names. Is there any other alternative?

Thanks in advance.

Regards,

Shyam.

Re: Replacing Database names in search object etc.

marcus_sommer — Fri, 09 Jan 2015 08:29:46 GMT

I think you will need to rename these fields but you could simplfy it with a mapping-table and a rename-statement like this:

rename fields using MapTab;

- Marcus