topic How to Change values name in the Field in QlikView

How to Change values name in the Field

kalyandg — Thu, 25 Apr 2013 06:21:56 GMT

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?

Re: How to Change values name in the Field

er_mohit — Thu, 25 Apr 2013 06:26:20 GMT

try this in load script

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

Re: How to Change values name in the Field

nilesh_gangurde — Thu, 25 Apr 2013 06:34:01 GMT

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

Re: How to Change values name in the Field

kalyandg — Thu, 25 Apr 2013 06:38:27 GMT

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

Re: How to Change values name in the Field

kalyandg — Thu, 25 Apr 2013 06:38:53 GMT

Hi nilesh ganrude,

Thanks for ur reply

Re: How to Change values name in the Field

nilesh_gangurde — Thu, 25 Apr 2013 06:41:43 GMT

Hiii Kalyan,

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

-Nilesh

Re: How to Change values name in the Field

er_mohit — Thu, 25 Apr 2013 06:49:34 GMT

For this you hv to use mapping function

CountryNamesMap:

Mapping

LOAD * INLINE [

ShowRoom, Name

India, Sroom1

China, Sroom2

Pak, Sroom3

US,Sroom4

];

Map NewName using CountryNamesMap;

LOAD * INLINE [

NewName

India

China

Pak

];

for other country u do it like this

Re: How to Change values name in the Field

kalyandg — Thu, 25 Apr 2013 07:04:59 GMT

HI MOHIT,

THANKS... THIS INLINE LOAD WORKS