Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Black_Hole
Contributor II

Rename fields in Chart Properties

Hello all,

I built a Chart Table in QlikView.

The data has been already loaded from 3 qvd files.

For some common fields between the 3 qvd files, I don't have the same label/name.

I would like to rename the fields without changing the name in the script.

That's why, I tried to modify the label in the Chart Properties.

 

But, that results in two columns in my table.

DuplicatedColumns.PNG

Please could you tell me if it's possible to rename the common fields between the 3 qvd files and without changing the script (using "AS").

Thank you in advance for your help.

1 Solution

Accepted Solutions
Highlighted

Re: Rename fields in Chart Properties

It's quite frequent that same QVW or QVDs are used by different people when those files are fed by the same source. Note that changing the name in the script does not change the name in the file, unless you STORE those files and overwrite them.

So they will change name in your datamodel, but they will not affect anyone else's apps, as the QVD will keep the same name.

If you do need to store the results of your renaming, I'd suggest using something like "_<username>" and to a broader extent, the use of the Qlik Deployment Framework, or similar mechanism to distinguish files being used from those which are available, and keep track of changes.

View solution in original post

4 Replies
Highlighted

Re: Rename fields in Chart Properties

In short: no, it's not possible.

If you don't change the name in the script, then they are actually not the same field, even if they have the same values. Charts rely on the data model to aggregate and display data, so depending what you want to show you will need to create a script fit for that purpose.

Is there any particular reason as to why keep the same field on both tables, if both fields are redundant? Would a JOIN between those tables help, if they have several fields in common?

Highlighted
Black_Hole
Contributor II

Re: Rename fields in Chart Properties

Hi @Miguel_Angel_Baeyens ,

First, thank you for your reply.

Fine, if there is no way to do like asked in my first post. I will modify in my script (I don't have the choice ^^).

To give you a reply to your question : "Is there any particular reason as to why keep the same field on both tables, if both fields are redundant? "

The reason is that the data loaded from the qvd files are not used just by me, but by many users.

Some users don't use the 3 qvd files at the same time but just one of them.

So, they don't have this issue and consequently they want to keep the "original" label.

Highlighted

Re: Rename fields in Chart Properties

It's quite frequent that same QVW or QVDs are used by different people when those files are fed by the same source. Note that changing the name in the script does not change the name in the file, unless you STORE those files and overwrite them.

So they will change name in your datamodel, but they will not affect anyone else's apps, as the QVD will keep the same name.

If you do need to store the results of your renaming, I'd suggest using something like "_<username>" and to a broader extent, the use of the Qlik Deployment Framework, or similar mechanism to distinguish files being used from those which are available, and keep track of changes.

View solution in original post

Highlighted
Black_Hole
Contributor II

Re: Rename fields in Chart Properties

Hi @Miguel_Angel_Baeyens ,

Thank you for sharing the link.

It will be a great help!