Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Help

Hi All,

Very new to Qlikview and trying to pick up something a former co-worker has done. Could someone explain what the following piece of script is doing?

ApplyMap('SFIDmapping_SF',[Level 3 Category],null()) as [SF ID],


   [Level 2 Category] as [Level 2 Process ID],
[Level 2 Detail] as [Level 2 Process Name],
[Level 3 Category] as [Level 3 Process ID],
[Level 3 Process Name],
[Name of Full HR Shared Services Service],
Comment,
[Team Accountable for Full HR Shared Services Service]

Basically what I am trying to do is count the number of cases by Team Accountable for Full HR Share Services Service. When I do this there is roughly 80000+ which come back with "-", does this mean its null or blank or can anyone give me any advice?

Thanks

3 Replies
Not applicable
Author

ApplyMap('SFIDmapping_SF',[Level 3 Category],null()) as [SF ID]


The above field SF_ID was created by ApplyMap function with SFIDMaoing_SF mapping table.


First read about Mapping tables and ApplyMap function.


Generally Mapping table have 2 fields like Key & Value pair, When you used ApplyMap, the key found its assign the Value to new field in the script.


You can check Level3 Category field exactly match with Mapping table First field values to debug why you got null values.

dena_reavis
Employee
Employee

David,

Also, these are two great posts on ApplyMap.

Henric Cronström: Qlik Design Blog : Don't join - use Applymap in... | Qlik Community

and

Steve Dark: http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Good luck!

Not applicable
Author

OK that makes sense, I assume the rest of the fields such as [Level 3 Process Name] is simply getting loaded into a table? .