Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 

Performance: ApplyMap in Preceding Map


I have noticed that this script runs about 4 times slower than the script at the bottom :


ApplyMap ( 'MapSicknessHours' , [SCD Environment Date Employee Key] , 0 ) as [Sickness Hours] ,




  [SCD Environment] & '|' &  [Date] & '|' &  [SCD Employee Number] as [SCD Environment Date Employee Key]  ,


resident Temp10


Whereas eliminating the Preceding Load is 4 times faster :


  ApplyMap ( 'MapSicknessHours' , [SCD Environment] & '|' &  [Date] & '|' &  [SCD Employee Number] , 0 ) as [Sickness Hours]
resident Temp10


I am curious as to why is the case.  Any ideas anybody ?

Normally I love preceding loads, but not in this case.

Best Regards,     Bill

1 Reply

Hi Bill,

The two scripts are not comparable.  In the preceding load, you are keeping the additional field "SCD Environment Date Employee Key".  It's a large string field, so could have significant impact on performance. An interesting comparison would be to not use * on the top load, but list the fields and don't keep "SCD Environment Date Employee Key".

In any case, I don't recommend using Preceding load in this scenario (adding one field). There is no benefit.