[{"_1":2,"_52":-5,"_53":-5},"loaderData",{"_3":4,"_14":15,"_50":-5,"_51":-5},"root",{"_5":-5,"_6":-5,"_7":-5,"_8":9,"_10":11},"user","shoppingCartId","toast","locale","en","constants",{"_12":13},"paypalClientId","AenrHU49peF-ZUH-Yq7AXLLNZYGUGlml474U16NCjB4ZznmQCEjiliN3whyuVZmkb7VxEzmTALgtKEKE","routes/_store+/_readers+/email_author.$slug/route",{"_16":17,"_49":-5},"book",{"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMTQwMTQ","title","QlikView for Ninjas","state","published","contactAuthorMethod","email","aboutText","

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:

https://dl.dropboxusercontent.com/u/24003637/DataSources.zip

https://dl.dropboxusercontent.com/u/24003637/AdventureWorks.zip

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

https://www.dropbox.com/s/hhq23wzrwuxvqtc/invoice_data.zip?dl=0

Date: 04-June-2015

Link to download new-accounts.xls file

https://www.dropbox.com/s/9msdhx8a1ekyryl/new-accounts.xlsx?dl=0

Date: 14-MAY-2015

Updated Invoice file: Added field UserID

https://www.dropbox.com/s/hv0pz18um59h4uw/dbo.Invoices.qvd?dl=0

Initial examples will be based on the AdventureWorks database.

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

http://www.sqldatadictionary.com/AdventureWorks2012.pdf

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.

","authors",[30,43],{"_18":31,"_32":33,"_5":34},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8xNDYxNg","name","Rajesh Pillai",{"_35":36},"avatar",{"_37":38,"_39":40,"_41":42},"url","https://d308did4coypzi.cloudfront.net/avatars/12952/medium/profile-1.jpg?1585039526","styleName","medium","exists",true,{"_18":44,"_32":45,"_5":46},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8xNDYxNw","Radhika Pillai",{"_35":47},{"_37":48,"_39":40,"_41":42},"https://secure.gravatar.com/avatar/094cd576b02726e6d84b9220a29619de?r=pg&d=mm","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Authors