Solved: Re: Qlik Formula - Qlik Community

xyz1 · ‎2017-02-09

.

sunny_talwar · ‎2017-02-09

Here it is

SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 1) * ApplyMap('MappingTable2', [EMP. NAME]&ROLE, 0) * ApplyMap('MappingTable3', [EMP. NAME]&Team, 0) * ApplyMap('MappingTable4', [EMP. NAME]&Month(Date#(Month, 'MMMM')), 0) as [REF BUILD],

SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 2) * ApplyMap('MappingTable2', [EMP. NAME]&ROLE, 0) * ApplyMap('MappingTable3', [EMP. NAME]&Team, 0) * ApplyMap('MappingTable4', [EMP. NAME]&Month(Date#(Month, 'MMMM')), 0) as OTHER,

SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 3) * ApplyMap('MappingTable2', [EMP. NAME]&ROLE, 0) * ApplyMap('MappingTable3', [EMP. NAME]&Team, 0) * ApplyMap('MappingTable4', [EMP. NAME]&Month(Date#(Month, 'MMMM')), 0) as RUN,

SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 4) * ApplyMap('MappingTable2', [EMP. NAME]&ROLE, 0) * ApplyMap('MappingTable3', [EMP. NAME]&Team, 0) * ApplyMap('MappingTable4', [EMP. NAME]&Month(Date#(Month, 'MMMM')), 0) as Enable

View solution in original post

sdmech81 · ‎2017-02-09

HI,

You can go through this,there functions like look up and apply map in qlikview

Joins and Lookups

sachin

sdmech81 · ‎2017-02-09

Or give excel data and mark there what all u want to look up

sachin

xyz1 · ‎2017-02-09

.

vardhancse · ‎2017-02-09

By seeing the script:

most of the things were vlookup, you can use Applymap().

After the above mentioned formula what is the data getting in to the excel?

xyz1 · ‎2017-02-09

.

xyz1 · ‎2017-02-09

.

sdmech81 · ‎2017-02-09

Hi,

Plss check this out..Its sttaight forward.

QlikView | Scripting | Lookup & ApplyMap Function - YouTube

With this u can map fields frm one to another table based on some attribute.Check above video plss

Sachin

xyz1 · ‎2017-02-09

.

sunny_talwar · ‎2017-02-09

Checking