From business requirements, data modeling, scripting, and visualizations to performance tuning for both beginners and advanced developers - it's everything you need in one book.

QlikView Your Business is an in-depth book that helps the reader to build a professional skill set for analyzing and visualizing data using QlikView and Qlik Sense.
The book contains a detailed hands-on QlikView and Qlik Sense tutorial that starts from the basics and continues into intermediate and advanced levels. It includes detailed descriptions of the most complex data modeling techniques, advanced scripting, Set Analysis, and advanced aggregation.

Who will benefit from this book?

Whether you are a beginner and you want to teach yourself QlikView and Qlik Sense, or you are an experienced developer and you just want to learn advanced techniques, this book is perfect for you!

Three key features that make “QlikView Your Business” a bestseller

1You get 800 pages of practical advice based on real business solutions
Oleg Troyansky, the author of the book, is a famous expert in the Qlik community, and he has more than 15 years of experience with Qlik products. In this book he shares his experience and knowledge with readers, which is why this book is not simply a collection of dry theories. Each concept is explained in the context of real business problems, and each thought is supported by many years of practical skills.
2This is a one-of-a-kind QlikView and Qlik Sense book, which was recognized as useful by both beginners and professionals alike.
On one hand, this is a step-by-step guide with several illustrations and examples written in an easy to understand language that will definitely be appreciated by the beginners. On the other hand, expert-level knowledge is described here as well, which will be useful to experienced Qlik developers that are seeking to harness advanced development techniques.
3The book contains almost all the necessary information you need in order to master QlikView and QlikSense at the appropriate level.
You won’t have to buy any other additional Qlik books. This comprehensive book has everything you need, whether you are a beginner dreaming of becoming a pro, or an advanced user who will be able to use it as a reference book.

What will you learn from this QlikView and Qlik Sense book?

The core of the book focuses on the process of developing QlikView applications using the QlikView Developer tool. This is presented in three main parts, covering three common business analysis scenarios: sales analysis, profitability analysis, and inventory analysis. The three parts describe techniques of increasing complexity, ranging from simple to advanced.
1Within each part, four chapters guide the reader through the four stages of developing an analytical solution in QlikView:

Understanding the business scenario and the common components of a solution

Defining the data model required for the analytical solution

Developing the QlikView Load Script that is used to build the data model

Developing the QlikView user interface (UI), or visualizations, used for the visual analysis

After reading each part and following the tutorials, the reader will have developed a complete and comprehensive QlikView solution.
1This book provides detailed coverage of advanced QlikView topics such as:

Advanced aggregation (AGGR)

Various aspects of set analysis and alternate states

Advanced scripting techniques

Advanced data modeling concepts

All data modeling, scripting and advanced visualization techniques described for QlikView, can be equally applied for Qlik Sense. Additionally, the book takes the reader through the concepts and methods of developing analytic dashboards with Qlik Sense, including loading the data and developing the visualizations and geo-mapping solutions.
The book's companion website includes sample data sets, scripts, and visualizations that support all of the examples in the book.

Here is what readers have to say…

M. Hanief Edwards

Great approach to develop Qlikview skills. Like that it also covers Qliksense. One caveat though: When I opened some of the supplied files. It was locked against personal license use. After ignoring the warning that the personal license would be restricted after opening restricted files, I lost my access...

James Harder

QlikView Your Business is an excellent resource for anyone wanting to learn and expand their knowledge of both QlikView and Qlik Sense. The principal author, Oleg Troyansky, is a well known and respected Qlik expert with years of experience in Qlik products. QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense. We provide "QlikView Your Business" to all of our Qlik Consultants at Visual Data Group and to all of our customers' business analysts and developers. Written extremely well, the book can be read from front to back as a course guide or kept by your keyboard as a ready reference book. Highly recommended! Jim Harder, Founder, Visual Data Group.


This is an outstanding book that all QlikView developers should pick up. The concepts discussed in the book are easy to pick up and the downloadable lessons are organized in such a way that you can skip around quite easily. The concepts covered in the book range from the mundane to the quite complex. I had the opportunity to recently meet with the author and his passion for QlikView was clearly made evident. This is an absolute must-have for your library if you are involved with QlikView.

Bill in CT

This is an excellent resource for anybody professionally serious about QlikView. The book is well organized and goes deep into subjects like data modeling, U/I optimization, and advanced functions. Where other books delve moderately, this book is unafraid. Oleg, Tammy, and Charlie make sure you understand the business context of their examples, but do not get bogged down with it. The differentiator is their complete and detailed explanations of Qlik functions and methods PLUS why and when they are best used. This is an expert level book, but is approachable for moderately experienced Qlikkies. Of the 5 Qlik books I own, this is definitely, unquestionably the best.

Would you like to talk to the author of this book?

Oleg Troyansky is not only the author of the book, he is a Qlik expert and a developer training coach with more than 15 years of Qlik experience. He is also the president of Natural Synergies, a company that provides a full range of services connected to working with Qlik products.
If you need any help with your Qlik project, fill out the form and we will contact you as soon as we can.

Ask a question and get
a free 15-minute consultation
with one of our Qlik Experts

    Buy now