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
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
chevron up
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

Examining advanced Table File Wizard options

The Table Files Wizard is used by many to load a file and generate the load script for it. However, there is a not-so-secret secret button with the word Next written on it that is often ignored:

There are some great things in here that are worth looking at.

Enabling a transformation step

When we first hit that Next button on the wizard, we are presented with the interesting option, Enable Transformation Step:

If we click on this button, it brings us to a new dialog with several tabs:

Garbage

The Garbage tab allows us to clean out records that are not useful to us. In the preceding screenshot, there are a couple of rows that we can select and click on the Delete Marked button to remove. We can also click on the Conditional Delete… button and set up a rule to delete particular rows, for example, if they begin with the word Total:

Fill

The Fill tab allows us to fill in missing values, or overwrite other values, based on a condition. We can fill data from...

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 Chapter 6
Next Chapter
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