Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

xyz1
Contributor III

.

.

1 Solution

Accepted Solutions

Re: Qlik Formula

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

24 Replies
sdmech81
Valued Contributor

Re: Qlik Formula

HI,

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

Joins and Lookups

sachin

sdmech81
Valued Contributor

Re: Qlik Formula

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

sachin

xyz1
Contributor III

.

.

vardhancse
Valued Contributor III

Re: Qlik Formula

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?

Highlighted
xyz1
Contributor III

.

.

xyz1
Contributor III

.

.

sdmech81
Valued Contributor

Re: Qlik Formula

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
Contributor III

.

.

Re: Qlik Formula

Checking