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
About the Author
About the Reviewers

Using Dual to handle period name sorting

QlikView does not have any data types. All data is stored as dual values, a number, and a text representation. Pure text values are still stored as dual, but just the number part is null.

A common field that is created in a QlikView script is the Month field linked to a date. This is a great example of dual because it has a number from 1 to 12, and a text representation from January to December. However, some companies, especially in their financial applications, have periods that do not start in January. For example, it is quite common for companies in the UK to have a financial year starting in April. In this recipe, we are going to create a Period field that has a period number and a matching month name that does not match the calendar year and month.

How to do it…

Use the following steps to use Dual to handle period name sorting:

  1. Load the following script:

      Date(TempDate) As Date,
      Year(TempDate) As Year,