renaming values if multiple values should have same values

[sanjeeva_279]

hi i like to rename filed values 

ex :

dalls to 001

houston  to 002

and austin and elpaso has 003 how to get values  by variable or expressions

dalls  001

houston 002

austin 003

elpaso 003

....................

[jobsonkjoseph]

Hi,

What is the output of renamed field you are expecting, your question is not clear.

Also, renaming of which axes are you referring in chart.

[sanjeeva_279]

Thanks for quick reply i need to know how to rename the field values as mentioned.

dalls to 001

houston to 002

and austin and elpaso has 003 how to get values by variable or expressions

dalls 001

houston 002

austin 003

elpaso 003

[MindaugasBacius · Accepted solution]

Well, in the back end you should use ApplyMap:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/Apply...

In the back end in the Calculated dimensions use nested If statement:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ConditionalFunctions/i...

[jyothish8807]

Hi Sanjeeva,

May be like this, i am  not completely clear on your requirement.

Load

Yourfiled,

replace(replace(replace(replace(Yourfield,'dalls','001'),'houston','002'),'austin','003'),'elpaso','003') as NewField

from <>;

[jobsonkjoseph]

Hi Sanjeeva,

Mindagaus reply would help you. Try to use applymap(). Below is the sample script, pls modify according to your requirement, if it helps.

map:
Mapping LOAD * INLINE [
    Month1, Month
    1, Jan
    2, Feb
    3, Mar
    4, Apr
    5, May
    6, June
    7, July
    8, Aug
    9, Sep
    10, Oct
    11, Nov
    12, Dec
];

table:
LOAD 
     applymap('map',Month) as Month,
    
FROM
[..\Downloads\data.xlsx]
(ooxml, embedded labels, table is data);

[Anonymous]

Hi,
Use Mapping you will get the solution as your requirements
refer below code

main:
Mapping
LOAD * Inline
[
region,id
dalls,001
houstan,002
austin,003
elpaso,003
];

temp:
LOAD * Inline
[
name,region
A,dalls
B,houstan
C,austin
D,elapso
];

main:
LOAD region,
ApplyMap('main',region,if(WildMatch(region,'elapso'),'003'))as code
Resident temp;
DROP Table temp;


Thanks

[sanjeeva_279]

thanks all for the quick help.
i tried as nested if and the code is below ,i wanted solution as variable

=if(sport='Backpacking Boots', 'Backpacking Boots',if( sport='Athletic' or sport='Baseball','sportsnew','others'))