Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Qlikview Unlocked
  • Table Of Contents Toc
  • Feedback & Rating feedback
Qlikview Unlocked

Qlikview Unlocked

By : Roger Stone, Andrew Dove
4.4 (9)
close
close
Qlikview Unlocked

Qlikview Unlocked

4.4 (9)
By: Roger Stone, Andrew Dove

Overview of this book

QlikView Unlocked will provide you with new insights to get the very best from QlikView. This book will help you to develop skills to work with data efficiently. We will cover all the secrets of unleashing the full power of QlikView, which will enable you to make better use of the tool and create better results for future projects. In the course of this book, we will walk you through techniques and best practices that will enable you to be more productive. You will gain quick insights into the tool with the help of short steps called ”keys,” which will help you discover new features of QlikView. Moving on you will learn new techniques for data visualization, scripting, data modeling, and more. This book will then cover best practices to help you establish an efficient system with improved performance. We will also teach you some tricks that will help you speed up development processes, monitor data with dashboards, and so on. By the end of this book, you will have gained beneficial tips, tricks, and techniques to enhance the overall experience of working with QlikView.
Table of Contents (11 chapters)
close
close
9
A. Hidden Image List
10
Index

Calculations and flags in the script

It's always a good idea to do as much work in the script as possible because the work only needs to be done once when the document is reloaded, not every time the user chooses a particular sheet or object.

Consider this requirement: products with prices between £10.00 and £19.99 need to be shown in a straight table with no other products visible. It would be easy enough to do this as an IF() statement in an expression:

Calculations and flags in the script

We suppress zero values and hide the column. However, if there are several thousand rows, screen performance could be poor.

Calculations and flags in the script

It would be better to do the work in the script if we can:

Product:
LOAD [Product Code], 
     [Supplier Product Code], 
     [Supplier No], 
     [Manufacturer Product Code], 
     [Manufacturer No], 
     [Short Description], 
     Kit, 
     Price,
     IF(Price > 9.99 AND Price < 20.00, 1, 0) AS [Check Price]
FROM
[..\QlikView Unlocked Data.xlsx]
(ooxml, embedded labels, table is Product); 

All...

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.
Qlikview Unlocked
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

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