Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to work with Apply Map

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

Tags (1)
4 Replies
martinpohl
Valued Contributor II

Apply Map sucks

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];

jason_michaelid
Honored Contributor II

Apply Map sucks

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

MVP
MVP

Apply Map sucks

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

ngulliver
Valued Contributor III

Re: How to work with Apply Map

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

Community Browser