Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates

Data reload performance issue when using ConvertToLocalTime() function in Qlik Sense and QlikView

No ratings
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht
Support
Support

Data reload performance issue when using ConvertToLocalTime() function in Qlik Sense and QlikView

Last Update:

Oct 7, 2022 3:59:03 PM

Updated By:

Albert_Candelario

Created date:

Oct 18, 2021 9:36:15 AM

You might have encountered a performance degrade for data reloads when using the function ConvertToLocalTime() only with one parameter "timestamp" since upgrade to QS Feb 2021 or/and QV 12.60 as reloads could take 3 times longer than with the previous version before the upgrade.

 

Environment

  • Qlik Sense February 2021, May 2021
  • QlikView 12.60, 12.60 SR1

 

 

 

Workaround:

Using the second parameter "place" in ConvertToLocalTime() improves the reload performance.

 

Cause

The described behaviour is related to a defect. The fix is was delivered for Qlik Sense Client Managed in November 2021 IR, August 2021 Patch 14, May 2021 Patch 9 and February 2021 Patch 14.

Product Defect ID: QB-7474

 

 

512 Views
Was this article helpful? Yes No
Version history
Last update:
‎2022-10-07 03:59 PM
Updated by:
Support