Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kalyandg
Contributor II

How to Change values name in the Field

Hi all,

I have one requirement,

Field name -- ShowRoom it has values such as
                    India,

                    China,

                    Japan,

                    Australia.....etc

I need not show the values as is original..

instead of India it should show as SRoom1,

               China as SRoom2....etc

how to change the value name in a field?

please help me to solve!

Also in one field Product it has some values with null values...i have to show null value as Others instead of - in chart. Please help me for this issue also?

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: How to Change values name in the Field

For this you hv to use mapping function

like

CountryNamesMap:

Mapping

LOAD * INLINE [

    ShowRoom, Name

    India, Sroom1

    China, Sroom2

     Pak, Sroom3

     US,Sroom4

];

Map NewName using CountryNamesMap;

LOAD * INLINE [

    NewName

    India

    China

    Pak

    US

   

];

for other country u do it like this

7 Replies
er_mohit
Honored Contributor II

Re: How to Change values name in the Field

try this in load script

if(ShowRoom=pick(match(ShowRoom,'India','China'),'Sroom1','Sroom2'),ShowRoom)as NewShowroom

nilesh_gangurde
Valued Contributor

Re: How to Change values name in the Field

Hii Kalyan,

You can use the below mentioned script at load time.

if(wildmatch(ShowRoom,'India'),'Sroom1',

     if(wildmatch(ShowRoom,'China'),'Sroom2',

          if(wildmatch(ShowRoom,'',' ') or isnull(ShowRoom),'NULL')))

Hope this will help you.

-Nilesh

kalyandg
Contributor II

Re: How to Change values name in the Field

hi mohit,

thanks for your reply...
but i have 26 showrooms...
so for all showrooms, whether i have to write in the script?

please reply

Thanks,

Kalyan

kalyandg
Contributor II

Re: How to Change values name in the Field

Hi nilesh ganrude,

Thanks for ur reply

nilesh_gangurde
Valued Contributor

Re: How to Change values name in the Field

Hiii Kalyan,

Request you to please mark the post as Correct ans or Helpfull Ans.

-Nilesh

er_mohit
Honored Contributor II

Re: How to Change values name in the Field

For this you hv to use mapping function

like

CountryNamesMap:

Mapping

LOAD * INLINE [

    ShowRoom, Name

    India, Sroom1

    China, Sroom2

     Pak, Sroom3

     US,Sroom4

];

Map NewName using CountryNamesMap;

LOAD * INLINE [

    NewName

    India

    China

    Pak

    US

   

];

for other country u do it like this

kalyandg
Contributor II

Re: How to Change values name in the Field

HI MOHIT,

THANKS... THIS INLINE LOAD WORKS

Community Browser