Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

.

.

1 Solution

Accepted Solutions
sunny_talwar

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

24 Replies
sdmech81
Specialist
Specialist

HI,

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

Joins and Lookups

sachin

sdmech81
Specialist
Specialist

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

sachin

xyz1
Creator III
Creator III
Author

.

vardhancse
Specialist III
Specialist III

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
Creator III
Creator III
Author

.

xyz1
Creator III
Creator III
Author

.

sdmech81
Specialist
Specialist

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
Creator III
Creator III
Author

.

sunny_talwar

Checking