Code

[#1]

hi All,

I Have a table by name Handset , which has a column called Platform and the contenet under platform are

java

mre

natvie,

N/A

browser

apple

android

ios

symbian

Now i want to display like  java mreas the same  but N/A and Browser should be named as N/A ,

and where ever we have android,ios,aplle it should be named as smart phones, and rest of the platform as others.

how do we write this code in Qlikview will some one can help me out with this please

[marwen_garwachi]

Try this :

if(wildmatch(Platform ,'java','mreas'),Platform ,

     if(wildmatch(Platform ,'N/A','Browser'),'N/A',

     If(wildmatch('Platform','android','ios','apple','smart phones','Others')))))

Regards

Marwen

[tcullinane]

use a map in the load script

create the table of platforms you want to replace and what you want them to become

eg:

map_Table:

Mapping

Load * inline [

mapfrom,mapto

Browser, N/A

apple, smartphone

ios, smartphone

... etc...

];

then when loading the handset table add in ;

applymap('map_Table',platform) as NewPlatform,

to either create a new 'Platform' field or another higher level field.

[#4]

no borhter i tried with ur code but its not working

[marwen_garwachi]

could you share a sample file ? 

Regrads,

Marwen

[Peter_Cammaert · Accepted solution]

Try this as a calculated dimension:

=if(match(Platform ,'java','mre'),'java' ,

     if(match(Platform ,'N/A','browser'),'N/A', 'Others'))

Make sure that the strings in the match() calls are exact copies of your input data.

See doc in attachment.

[#7]

Hi pcammaert

Thanks dude ,  its working fine now