Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Mapping

Hi guys,

I got a script in which has a mapping table like:

User:

mapping load

userId,

companyCode

resident T1;

Then there's something like:

Applymap('User',rewardUser,' ')

I don't really get this. Does it mean User mapping table maps userId to companyCode? If so, what is rewardUser in ApplyMap?

Thanks in advance!

1 Solution

Accepted Solutions
maxsheva
Contributor

Re: Mapping

Hi,

I suppose Applymap() is somewhere in other table.

It loads rewardUser from source.


Applymap function is looking for values from rewardUser in userId field.

If equals then take companyCode value.


Please check for details https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Mapp...

2 Replies

Re: Mapping

rewardUser is the field in the table where ApplyMap is used.

This applymap will give you companyCode from User Mapping Load table.

You can read further how it works from here.

Don't join - use Applymap instead

maxsheva
Contributor

Re: Mapping

Hi,

I suppose Applymap() is somewhere in other table.

It loads rewardUser from source.


Applymap function is looking for values from rewardUser in userId field.

If equals then take companyCode value.


Please check for details https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Mapp...

Community Browser