Renaming certain Fields to custom Names

[DWolsie]

Hello everyone,

I've got a problem that I haven't found a solution to yet.

I've got a pie chart, but I want to change the naming of the dimension to something custom. For example, 0017505000 should be renamed to 17-5 and so on.

Is there a simple or elegant solution to this problem? Thanks in Advance!

[VBD · Accepted solution]

Hello,

The best way to do that is in Data load editor with a mapping table :

https://help.qlik.com/fr-FR/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctio...

But if you don't have access to script, you can use a formule like this in your dimension :

=pick(match(DIM,'0017500000','0017600000','0017700000','0017800000','0017900000')
,'17-5','17-6','17-7','17-8','17-9')

DIM is the dimension you want to change, '0017500000','0017600000','0017700000','0017800000','0017900000' are you real values, and 

'17-5','17-6','17-7','17-8','17-9' are the value you want to display.

The real value and the value you want to display need to be at the same position

For example 0017700000 is in a third place, so of the function match() so '17-7' needs to be at the third place of the pick() function.

Regards,

[Qrishna]

provide some more data.

just with this one value 0017505000  we can do a lot in different methods, but if pyu provide some more additional data, probabaly we could find a pattern and find a solution.

thnx