topic How to work with Apply Map in QlikView

How to work with Apply Map

Tue, 22 May 2012 06:28:43 GMT

Hi help me.

I have this items

ITEM TABLE

Item Code

ACC001

LTP334

MEM455

GIG991

how can I apply map?

CLASS

Code Classname

ACC Accesory

LTP Laptop

Mem Memory

Please use apply map. I'm using QV11... It dares me coz it does not run, dont know why!

And note that the last item GIG991 not exist in CLASS so it's automatic that the classname for this item is OTHERS.

I really need help. Thanks.

-Bill

Apply Map sucks

martinpohl — Tue, 22 May 2012 07:48:38 GMT

load [Item Table];

classmapping:

mapping LOAD * INLINE [

Code, Classname

ACC, Accesory

LTP, Laptop

Mem, Memory

];

load

[Item Code],

applymap('classmapping', left([Item Code],3),'Others' as Classname

resident [Item Table];

Apply Map sucks

Jason_Michaelides — Tue, 22 May 2012 07:53:51 GMT

How dare you sir! ApplyMap() is awesome!!

Apply Map sucks

Miguel_Angel_Baeyens — Tue, 22 May 2012 08:00:36 GMT

Hi Bill,

Please mind your language and keep it thoughtful: it's very different to ask for help that to ask for your work done. While the latter may prevent people to help you, the former will attract people to suggest. I'd strongly recommend you to check here on how to get the best from QlikCommunity.

Regards.

Miguel

Re: How to work with Apply Map

ngulliver — Tue, 12 Jun 2012 15:11:02 GMT

Hi, Bill.

There is some useful advice on ApplyMaps here:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/.

It's worth a look to give you an idea of it's true capabilities.

Cheers,

Neil