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.
  • Book Overview & Buying Mastering QlikView
  • Table Of Contents Toc
  • Feedback & Rating feedback
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

Using control structures

Any basic development language will include some control structures to either repeat the execution of particular tasks or change what task will happen next based on conditions. QlikView is no different, so in this section we will examine the various options.

Branching with conditional statements

It can be enormously important to be able to execute different sets of statements based on different conditions. It gives us a lot of flexibility in implementing our solutions.

If … Then … ElseIf

If ... Then ... ElseIf is a fairly fundamental construct in many programming languages. We test a condition, and if it is true, we execute one set of statements. If it isn't true, then we can either execute a different set of statements or perform a new test and keep going.

As an example, if we wanted to test whether a file exists before trying to load it:

If Alt(FileSize('c:\temp\Data.qvd'),0)>0 Then

  Data:
  Load *
  From c:\temp\Data.qvd (qvd);

End if

Note

We use Alt here because...

Visually different images
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 6
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