topic ApplyMap Usage in QlikView

ApplyMap Usage

Fri, 24 Apr 2009 00:09:29 GMT

Hi,

Please explain when in which scenario we need to use the applymap ?Please give one simple example.

-Lary

ApplyMap Usage

rbecher — Fri, 24 Apr 2009 00:41:21 GMT

It's for simple mapping purposes like this:

input => output
1 => A
2 => B
2 => C

Map1:
mapping load * inline [x,y
1,A
2,B
3, C] ;

ApplyMap ( 'Map1', 2 )

returns

Ralf

ApplyMap Usage

Anonymous — Wed, 29 Apr 2009 08:54:33 GMT

Lary,

Here is a scenario:
Thre is a table "Users" that contains UserId and UserName. There is another table "Organisations", where there are fields OwnerId, which contains UserId, and ProjectManagerId also contains UserId. And one more table, Orders, with fields AccountId and SalesRepId. You want Orders linked Organizations by AccountId, and not by any users.
to deal with all these multiple User roles, create map:


UserMap:
MAPPING SQL SELECT DISTINCT
UserId,
UserName
FROM Users;

And use it as many times as you want:
applymap('UserMap', OwnerId) as "Account Owner"
applymap('UserMap', ProjectManagerId ) as "SaleProject Manager"
applymap('UserMap', SalesRepId) as "Sales Rep"
...
In the other words, it is used here as a picklist. Not the only possible use of the aplymap, but probably the most typical.

Regards,
Michael

ApplyMap Usage

ngulliver — Tue, 01 May 2012 16:06:24 GMT

Lary.

Have a look at http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/. There is some good info her for applymaps.

Cheers,

Neil