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

Reviewing basic concepts

Before we set off on the journey of advanced expressions, it is a good idea to step back and look at some of the simpler methods of doing things. Set Analysis only arrived in Version 8.5 of QlikView, so those of us who worked with the versions before that will have done things in a few different ways.

Searching in QlikView

Field searching in QlikView is one of the most powerful features. It is a feature that has been added and enhanced over the years. Many users will be familiar with the search icon on a listbox:

Clicking on this icon will open the search box for that field:

When we enter search text, the results are highlighted in the listbox. We can choose to click on any of the results to make a selection, press the Enter key to select all of the matching results, or press Ctrl + Enter to add the matching results to the existing selections.

There are some other ways that we can call up the search box for a listbox. The easiest way is to actually just click on the listbox...

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 5
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