Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering QlikView
  • Table Of Contents Toc
Mastering QlikView

Mastering QlikView

By : Stephen Redmond
4.5 (10)
Buy this Book
close
close
Mastering QlikView

Mastering QlikView

4.5 (10)
By: Stephen Redmond
Buy this Book

Overview of this book

If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics.
Table of Contents (9 chapters)
close
close
close
Preface
Icon
Preface
Icon
Qlik Sense
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Icon
Downloading the example code
Lock Free Chapter
1
1. Performance Tuning and Scalability
Icon
1. Performance Tuning and Scalability
Icon
Reviewing basic performance tuning techniques
Icon
Generating test data
Icon
Understanding how QlikView stores its data
Icon
Strategies to reduce the data size and improve performance
Icon
Testing chart performance for different load options
Icon
Optimizing chart calculation times
Icon
The QlikView calculation engine
Icon
Using Direct Discovery
Icon
Testing scalability with JMeter
Icon
Running an example execution
Icon
Summary
2
2. QlikView Data Modeling
Icon
2. QlikView Data Modeling
Icon
Reviewing basic data modeling
Icon
Dimensional data modeling
Icon
Handling slowly changing dimensions
Icon
Dealing with multiple fact tables in one model
Icon
Drilling across with document chaining
Icon
Summary
3
3. Best Practices for Loading Data
Icon
3. Best Practices for Loading Data
Icon
Reviewing data loading concepts
Icon
Understanding why you should use an ETL approach
Icon
Using an ETL approach to create QVD data layers
Icon
Mastering loading techniques
Icon
Using QlikView Expressor for ETL
Icon
Summary
4
4. Data Governance
Icon
4. Data Governance
Icon
Reviewing basic concepts of data governance
Icon
Establishing descriptive metadata
Icon
Extracting metadata
Icon
Deploying the QlikView Governance Dashboard
Icon
Summary
5
5. Advanced Expressions
chevron up
Icon
5. Advanced Expressions
Icon
Reviewing basic concepts
Icon
Understanding Dollar-sign Expansion
Icon
Using advanced Set Analysis
Icon
Calculating vertically
Icon
Summary
6
6. Advanced Scripting
Icon
6. Advanced Scripting
Icon
Reviewing the basic concepts
Icon
Counting records
Icon
Loading data quickly
Icon
Applying variables and the Dollar-sign Expansion in the script
Icon
Using control structures
Icon
Examining advanced Table File Wizard options
Icon
Looking at data from different directions
Icon
Reusing code
Icon
Summary
7
7. Visualizing Data
Icon
7. Visualizing Data
Icon
Reviewing the history of data visualization
Icon
Understanding the audience
Icon
Designing effective visualizations
Icon
Summary
8
Index
Icon
Index

Chapter 5. Advanced Expressions

 

"The general who wins a battle makes many calculations in his temple before the battle is fought. The general who loses a battle makes but few calculations beforehand. Thus do many calculations lead to victory, and few calculations to defeat: how much more no calculation at all! It is by attention to this point that I can foresee who is likely to win or lose."

 
 --Sun Tzu, The Art of War

There is a great skill in creating the right expression to calculate the right answer. Being able to do this in all circumstances relies on having a good knowledge of creating advanced expressions. This is what this chapter aims to teach you. Of course, the best path to mastery in this subject is actually getting out and doing it, but there is a great argument here for regularly practicing with dummy or test datasets.

When presented with a problem that needs to be solved, all the QlikView masters will not necessarily know immediately how to...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering QlikView
End of Section 5
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon