Book Image

QlikView for Developers Cookbook

By : Stephen Redmond
Book Image

QlikView for Developers Cookbook

By: Stephen Redmond

Overview of this book

QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access. QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions. Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise. From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about. The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.
Table of Contents (19 chapters)
QlikView for Developers Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Setting the default display format


The default document format for a numeric value (the text part of the dual value) is decided on by QlikView when the field is first loaded. This can be a problem if the incoming data is unclean, or you want to change the format as it is loaded.

The usual approach is to use one of the formatting functions, like Num or Date, to apply the format as it is being loaded. This can be troublesome if you are loading from QVD and want to retain the QVD optimization on loading—adding a Num or Date function would lose that optimized load.

There is another way. In this recipe, we can see that by loading the data in a temporary table first, we can force the format for the rest of the data.

Getting ready

Load the following script:

Data:
Load * Inline [
  Date, Value
  2013-01-01, 1234.56
  2013-01-14, 3245
  2013-03-12, 2389.6
];


Store Data into Data.qvd;

Drop Table Data;

Data:
Load * From Data.qvd (QVD);

How to do it...

These steps show you how to set a default display...