Skip to Main Content
QlikView for Developers Cookbook
book

QlikView for Developers Cookbook

by Stephen Redmond
June 2013
Beginner to intermediate content levelBeginner to intermediate
290 pages
4h 59m
English
Packt Publishing
Content preview from QlikView for Developers Cookbook

Reducing the number of distinct values

QlikView's columnar data storage method is extremely efficient at storing data because it does not store repeating values. Each unique value is only stored once. This means that, in general, a QlikView in-memory data set will always be much smaller than the original data source.

This efficiency is lost, however, when the data is highly distinct. The more distinct the values that exist within the data, the more space that QlikView will need to store it in memory. The worst offenders for this are often ID fields and time stamps, and if we can remove these, then we will make our document more efficient.

Getting ready

Load the following script:

// Build a list of city/countries City_Country: Load * Inline [ CityID, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

QlikView for Developers

QlikView for Developers

Miguel Angel Garcia, Barry Harmsen
QlikView 11 for Developers

QlikView 11 for Developers

Miguel Angel Garcia, Barry Harmsen

Publisher Resources

ISBN: 9781782179733Other