topic Re: Rename fields in Chart Properties in QlikView

Rename fields in Chart Properties

Black_Hole — Sat, 16 Nov 2024 01:53:25 GMT

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.

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.

Re: Rename fields in Chart Properties

Miguel_Angel_Baeyens — Fri, 22 Nov 2019 09:38:49 GMT

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?

Re: Rename fields in Chart Properties

Black_Hole — Fri, 22 Nov 2019 13:47:59 GMT

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.

Re: Rename fields in Chart Properties

Miguel_Angel_Baeyens — Tue, 26 Nov 2019 15:31:57 GMT

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.

Re: Rename fields in Chart Properties

Black_Hole — Tue, 26 Nov 2019 16:31:17 GMT

Hi @Miguel_Angel_Baeyens ,

Thank you for sharing the link.

It will be a great help!