topic Re: renaming values if multiple values should have same values in QlikView

renaming values if multiple values should have same values

sanjeeva_279 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: renaming values if multiple values should have same values

jobsonkjoseph — Fri, 16 Nov 2018 05:22:14 GMT

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.

Re: renaming values if multiple values should have same values

sanjeeva_279 — Fri, 16 Nov 2018 05:43:02 GMT

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

Re: renaming values if multiple values should have same values

MindaugasBacius — Fri, 16 Nov 2018 05:49:54 GMT

Well, in the back end you should use ApplyMap:

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

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/if.htm

Re: renaming values if multiple values should have same values

jyothish8807 — Fri, 16 Nov 2018 06:06:39 GMT

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 <>;

Re: renaming values if multiple values should have same values

jobsonkjoseph — Fri, 16 Nov 2018 06:24:09 GMT

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);

Re: renaming values if multiple values should have same values

Anonymous — Fri, 16 Nov 2018 07:31:40 GMT

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

Re: renaming values if multiple values should have same values

sanjeeva_279 — Fri, 16 Nov 2018 08:13:41 GMT

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'))