Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
no borhter i tried with ur code but its not working
could you share a sample file ?
Regrads,
Marwen
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.
Hi pcammaert
Thanks dude , its working fine now