Packt Publishing has released my book, QlikView Scripting. This title is the latest in a number of titles about QlikView from some really great QlikView experts. My book was written for beginning to intermediate QlikView developers and BI practitioners to really focus in on what is arguably the most critical aspect of any QlikView project — the data model creation (scripting!) process. It’s a fairly short book at 138 pages(Packt requested a mini-book, and it was a challenge to keep it to the current lengthened page count, much less the page count they requested initially), but I feel like it’s packed (Packt?) full of useful information and tips.
I am honored to have some really excellent technical reviewers that helped me along with the text: Steve Dark, Ralf Becher, Anthony Perozzo, and Deepak Vadithala. Steve Dark is one of the most respected QlikView experts in the world, and runs the QlikView consultancy Quick Intelligence, located in the UK and consulting worldwide. Steve’s excellent blog, Quick Intelligence, is a great resource of education and pro tips for QV developers everywhere. Thanks to Steve also for the nice review on Quick Intelligence blog. Ralf Becher runs the Leipzig-based data consultancy TIQ Solutions and has worked with QlikView for many years, designing data management and architecture solutions, particularly involving big data and Java. Ralf’s great QlikView-oriented blog is located at http://tiqview.tumblr.com/ . I’ve also been fortunate to have Anthony Perozzo, a Belgium-based software developer and project manager and globe trotter, who unfortunately does not have a blog I can point to, though I would like him to start blogging. And last but not least, Deepak Vadithala, BI professional extraordinaire and Qlikshare blogger – his excellent QlikView posts and tips and videos can be found at his blog http://qlikshare.com/ .
Here is the book description of QlikView Scripting from the publisher:
- Understand everything about QlikView, from structuring a script to fixing it to charting object problems
- Packed full of information and code examples to help you to understand the key concepts and features of QlikView
- Informative screenshots help you navigate QlikView’s scripting menus and dialogs
QlikView is a powerful business intelligence and data discovery platform that allows people to quickly develop relevant data visualization applications for business users. The relative ease of QlikView development—including backend scripting—allows applications to be developed rapidly, and allows for more collaboration in application development for business users.
A comprehensive guide that offers QlikView developers a rich discussion of scripting topics, from basic to advanced concepts, features, and functions in a compact mini-book format. This book allows developers to quickly gain confidence in understanding and expanding their QlikView scripting knowledge, and serves as a springboard for even more advanced topics in QlikView scripting.
The book starts off by covering basic topics such as connecting to data sources, scripting, dealing with load statements, data transformations, and the concepts of the basic data model. It then dives into advanced concepts such as advanced scripting and data model optimization, the creation and use of QlikView datafiles, debugging, and essential functions and features. It also provides layout tips for developers. Qlikview Scripting is a great overview and reference guide for beginner to intermediate Qlikview developers.
What you will learn from this book
- Connect to various data sources, from external files to OLEDB/ODBC databases
- Develop and structure a QlikView script
- Transform data while loading from an external script
- Discover the QlikView data modeling theory and the importance of structuring the data model
- Optimize the data model through the use of table join concatenations, key tables, interval matching, and other useful scripting features
- Use the QlikView Table Viewer to help you structure your data model
- Create, use, and view information contained in QlikView data files (QVDs)
- Debug QlikView scripts and fix problems using the syntax checker, logs, and the QlikView Debugger
- Leverage dimensions and expressions in QlikView chart objects in the presentation layer
- Understand common and useful QlikView script functions and expressions
This mini book offers information about QlikView scripting written in an easy-to-understand manner, and covers QlikView scripting from basic to advanced features in a compact format.
Who this book is written for
If you are a basic or intermediate developer with some knowledge of QlikView applications and a basic understanding of QlikView scripting and data extraction and manipulation, this book will be great for you. If you are an advanced user, you can also use this book as a reference guide and teaching aid. If you are a QlikView project team member such as a business user, data/ETL professional, project manager, or systems analyst, you can also benefit from gaining an understanding of the structure and the challenges of writing an efficient and useful QlikView application.