QlikView for Ninjas
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.
The real world case study data files can be downloaded from the below link.
Link to download new-accounts.xls file
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
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
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.
- 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
- Case study requirements
- 14 – Advanced Data Transformation
15 – Joins and Keep
- Inner Join
- Left Join
- Right Join
- Outer Join
- 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.
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.