Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

4 Replies
martinpohl
Partner - Master
Partner - Master

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_Michaelides
Luminary Alumni
Luminary Alumni

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

Miguel_Angel_Baeyens

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
Partner - Specialist III
Partner - Specialist III

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