Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Expressor - Creating and Managing In-Memory Lookup Tables

Not applicable

QlikView Expressor - Creating and Managing In-Memory Lookup Tables

For situations in which lookup table volumes are relatively small (e.g., <100,000 records), using in-memory Datascript tables for efficiently storing and retrieving values by keys can be as mush as 5 to 10 times faster than using a Lookup Table and Lookup Rule in QlikView Expressor dataflows.  This document describes the implementation of a Datascript Module that supports the creation, persistence, reloading and usage of lookup tables based on an in-memory Datascript table.

Attached to this posting is a .zip file that includes a Datascript module that implements an in-memory lookup table and a document that describes its usage.

Attachments
Version history
Revision #:
1 of 1
Last update:
‎12-11-2013 10:57 PM
Updated by: