topic Re: Code in QlikView

Code

Tue, 06 Jan 2015 14:14:58 GMT

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

Re: Code

marwen_garwachi — Tue, 06 Jan 2015 14:25:54 GMT

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

Re: Code

tcullinane — Tue, 06 Jan 2015 14:33:21 GMT

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.

Re: Code

Tue, 06 Jan 2015 15:10:51 GMT

no borhter i tried with ur code but its not working

Re: Code

marwen_garwachi — Tue, 06 Jan 2015 15:44:48 GMT

could you share a sample file ?

Regrads,

Marwen

Re: Code

Peter_Cammaert — Tue, 06 Jan 2015 15:54:12 GMT

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.

Re: Code

Wed, 07 Jan 2015 06:12:30 GMT

Hi pcammaert

Thanks dude , its working fine now