QlikView for Ninjas
With Membership
Suggested price

QlikView for Ninjas

The first and ultimate step to the exciting world of QlikView

About the Book

QlikView for Ninja series is a first in a series of books covering all aspects of QlikView Devlopment and designing.  Subsequent series will cover advanced aspects and drill into more details of each topics.  This will be the biggest of the volume in the series. Hope you will enjoy reading this book as much as I am enjoying writing it.  

You can download all the datasources and upcoming scripts from the below location.

Data Sources:



The real world case study data files can be downloaded from the below link.


Date: 04-June-2015

Link to download new-accounts.xls file


Date: 14-MAY-2015

Updated Invoice file:  Added field UserID


Initial examples will be based on the AdventureWorks database.

Also, to understand the data model for AdventureWorks database, you can refer the below document.


The actual case study will be building data models and dashboards for an Invoicing Application.

NOTE:  The price of this book will be revised once the book's first version is out.  So, take this opportunity to grab this as an early adopter.

The draft outline of the agenda is given below.

SECTION 1 - QlikView Developer

1. Introduction

2. QlikView Development Methodology

3. Data and Scripting

4. Connect, Select and Load

5. Loading Data from SQL Server

   - Executing Stored Procedures

   - Reading XML Data from SQL Server

6. Loading Data from XML file

7. Loading Data from Excel and CSV files

8. Data Modelling Issues

9. Referencing external files

10. Basic Data Transformation

11. Data generation in the QlikView script

12. Scripting Best Practices

13. Master Calendar

14. Mapping Tables

15. Data Model Optimization

16. Link Tables

17. Interval Match

18. Cross Tables

19. Advanced Calculations 

20. Alternate States

21. Set Analysis

22. Metadata

23. Generating QVD's

24. QlikView Security

25. Additional Load Types

26. How to use QlikView Extensions

NOTE:  All the sections will be moved to another book (and all readers will get a free copy when published)

SECTION 2 - QlikView Designer (Same book or new book)

SECTION 3 - Basic Server Administration  (Same book or could be new book)

SECTION 4 - Advanced Development and Tips and Tricks (Already available on leanpub.com as "QlikView Recipes")

If any section is move to a new book, the existing subscribers will get it free.

About the Authors

Rajesh Pillai
Rajesh Pillai

I am the Co-Founder of Algorisys Technologies where we specialize in providing solutions using Open source stack inlcuding but not limited to, MS technologies, HTML5, javascript, ruby on rails, nodejs, react, angular etc.  I have about 22+ years of overall software development experience covering major roles across different verticals.

My free early access tutorials are hosted at https://teachyourselfcoding.com/

I blog at https://teachyourselfcoding.com/blog

My video tutorials are at https://www.youtube.com/tekacademylabs

My LinkedIn profile is at http://in.linkedin.com/in/pillairajesh/

Table of Contents

  • 1 - Introduction
  • 2 - QlikView Development Methodology
  • 3 - Developer Roles
  • 4 - Data and Scripting
    • QlikView Data Modelling
  • 5 - Connect, Select and Load
  • Case study - Data modelling for Invoice Management System
  • 6 – Loading data
  • 7 – Synthetic Keys
  • 8 – Circular Reference
  • 9 – Loading additional tables
  • 10 – Mapping Tables
  • 11 – Master Calendar
  • 12 – Load Types
    • Resident Load
    • Inline Load
  • 13 – Concatenation
    • Automatic Concatenation
    • NoConcatenate
    • Case study requirements
  • 14 – Advanced Data Transformation
  • 15 – Joins and Keep
    • Inner Join
    • Left Join
    • Right Join
    • Outer Join
  • Keep
  • 16 – Applying ApplyMap()
  • 17 – Interval Match
  • SECTION 2 - Programming for QlikView Ninjas
  • SECTION 3 – Tips and Tricks
  • This section will contain tips and tricks from the field.
  • 1 – Auto reload a QlikView Document
  • Section 4 - Incremental Load
  • Appendix – A – Loading Data from Sql Server
    • Loading data through SQL Server Stored Procedure

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $12 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub