Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

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
Master II
Master II

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

View solution in original post

7 Replies
er_mohit
Master II
Master II

try this in load script

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

nilesh_gangurde
Partner - Specialist
Partner - Specialist

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
Partner - Creator III
Partner - Creator III
Author

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
Partner - Creator III
Partner - Creator III
Author

Hi nilesh ganrude,

Thanks for ur reply

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hiii Kalyan,

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

-Nilesh

er_mohit
Master II
Master II

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
Partner - Creator III
Partner - Creator III
Author

HI MOHIT,

THANKS... THIS INLINE LOAD WORKS