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

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Mastering QlikView
  • Toc
  • feedback
Mastering QlikView

Mastering QlikView

By : Stephen Redmond
4.5 (10)
close
Mastering QlikView

Mastering QlikView

4.5 (10)
By: Stephen Redmond

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
Preface
Preface
Qlik Sense
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Free Chapter
1
1. Performance Tuning and Scalability
1. Performance Tuning and Scalability
Reviewing basic performance tuning techniques
Generating test data
Understanding how QlikView stores its data
Strategies to reduce the data size and improve performance
Testing chart performance for different load options
Optimizing chart calculation times
The QlikView calculation engine
Using Direct Discovery
Testing scalability with JMeter
Running an example execution
Summary
2
2. QlikView Data Modeling
2. QlikView Data Modeling
Reviewing basic data modeling
Dimensional data modeling
Handling slowly changing dimensions
Dealing with multiple fact tables in one model
Drilling across with document chaining
Summary
3
3. Best Practices for Loading Data
3. Best Practices for Loading Data
Reviewing data loading concepts
Understanding why you should use an ETL approach
Using an ETL approach to create QVD data layers
Mastering loading techniques
Using QlikView Expressor for ETL
Summary
4
4. Data Governance
chevron up
4. Data Governance
Reviewing basic concepts of data governance
Establishing descriptive metadata
Extracting metadata
Deploying the QlikView Governance Dashboard
Summary
5
5. Advanced Expressions
5. Advanced Expressions
Reviewing basic concepts
Understanding Dollar-sign Expansion
Using advanced Set Analysis
Calculating vertically
Summary
6
6. Advanced Scripting
6. Advanced Scripting
Reviewing the basic concepts
Counting records
Loading data quickly
Applying variables and the Dollar-sign Expansion in the script
Using control structures
Examining advanced Table File Wizard options
Looking at data from different directions
Reusing code
Summary
7
7. Visualizing Data
7. Visualizing Data
Reviewing the history of data visualization
Understanding the audience
Designing effective visualizations
Summary
8
Index
Index

Summary

This chapter has given us a lot of information on an area that many QlikView developers might rather avoid—metadata. However, we should realize now that metadata is important, and more importantly, is straightforward to add to our QlikView applications.

We now have a range of tools to help us manage our metadata, including the QlikView Governance Dashboard.

In the next chapter, we will get into the, fun for many, subject of advanced expressions. This will include plenty of work around the subjects of Set Analysis and AGGR, which are very powerful tools that will really propel our mastery of QlikView.

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Chapter 4
Next Chapter
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete