[{"_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","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMjI4NDI","title","QlikView Recipes","state","published","contactAuthorMethod","email","aboutText","

In case you have already purchased \"QlikView for Ninjas\" book, you might already have got an email for a free subscription to this new book. In case you haven't yet received an email, kindly drop me a message through the book's website, so that I can email you the coupon code.

QlikView Recipes is a collection of tips, tricks, challenges across all work area of QlikView design, development and deployment.

This is a work in progress and every week 1 chapter will be added.

NOTE: This is not a beginners level book. Some basic knowledge of QlikView is assumed to work effectively with this book.

Chapters Published:

Contents

==========

Prologue

Section 0 - Introduction

Section 1 – Scripting and Reusable functions

===============================================

1. Automatically create variables from script.

2. Automatically create QVD’s from the data sources.

Section 2 – Charts

===================

3. Fast Change Chart Using Action button (Macro)

4. Ad Hoc Analysis

Section 3 – Date and Time

=========================

3. Use floor() function to reduce number of unwanted records in date field.

4. NetworkDays() Get the number of working days

5. Get working days including Saturday

6. Load Date data from text files/inline in the correct format.

7. Select date between two variables (start and end)

","authors",[30,43],{"_18":31,"_32":33,"_5":34},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8yMzc0OQ","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},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8yMzc1MA","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