Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
QlikView for Developers Cookbook
QlikView for Developers Cookbook

QlikView for Developers Cookbook: Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable.

Arrow left icon
Profile Icon Stephen Redmond
Arrow right icon
$19.99 per month
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (24 Ratings)
Paperback Jun 2013 290 pages 1st Edition
eBook
$9.99 $28.99
Paperback
$48.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Stephen Redmond
Arrow right icon
$19.99 per month
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (24 Ratings)
Paperback Jun 2013 290 pages 1st Edition
eBook
$9.99 $28.99
Paperback
$48.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
$9.99 $28.99
Paperback
$48.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

QlikView for Developers Cookbook

Chapter 2. Layout

In this chapter, we will cover:

  • Changing the default object layout options

  • Changing the default selection color scheme

  • Modifying the green, white, and gray selection color schemes

  • Modifying the green, white, and gray selection color schemes on QlikView Server

  • Using containers as an alternative to multi-boxes

  • Using the design menus to custom format a cell

Introduction


There are some best practices that one should always follow when creating a layout in QlikView.

For general advice on visualizing data, I recommend the following people:

Name

Publication

Website

Stephen Few

Show Me The Numbers, Information Dashboard Design, and Now You See It.

www.perceptualedge.com

Robert Kosara

Eager Eyes Blog

www.eagereyes.org

Andy Kirk

Data Visualization: a successful design process

www.visualisingdata.com

Alberto Cairo

The Functional Art

www.thefunctionalart.com

There are, of course, many others on note, but the list could go for several pages and you wouldn't get to the bottom of it!

My purpose in this chapter is to show you how to layout and configure documents so that you can implement best practices.

Changing the default object layout options


The default layout option in QlikView is Simplified. When you look at the Layout tab of any object, you will only see, two options on the left-hand side: Shadow Intensity and Border Width:

While these options suffice for 99 percent of all layouts, there are many other options that we can make available to us, if required.

Getting ready

Open any existing QlikView document with at least one listbox (perhaps one of the documents from Chapter 1, Charts).

How to do it…

Follow these steps to change the default layout options:

  1. From the Settings menu, click on Document Properties (Ctrl + Alt + D).

  2. On the General tab, set the Styling Mode to Advanced. Click on OK to close the properties.

  3. Notice that the sheet objects have changed already, probably with rounded corners.

  4. Open the properties of any object and look at the Layout tab. Notice that there are now many more options.

  5. Modify the options and notice what happens.

How it works…

Enabling the Advanced styling mode...

Changing the default selection color scheme


QlikView has six precanned color schemes, such as Classic, Forest, Spring, Lime, Classic Extended, and Light. Out of box, the default selection color scheme is Light. The Possible options have white background, the Selected options are green, and the Excluded options have a very light gray.

On some displays, especially projectors or plasma screens, the colors do not come out as well; especially the light gray can look almost white.

Also, business users sometimes request that the color scheme be changed. While it is not straightforward to change from the green/white/gray options, there are several options to choose from (as long as they are green/white/gray!).

Getting ready

Open any existing QlikView document with at least one listbox (perhaps one of the documents from Chapter 1, Charts).

How to do it…

These steps will show you how to change the default color scheme:

  1. From the Settings menu, click on Document Properties (Ctrl + Alt + D).

  2. On the General...

Modifying the green, white, and gray selection color schemes


QlikView selection colors are green/white/gray. They have a brand around this and are not keen for anyone who can change them.

It is, however, possible to do so. We will use the QlikView API to modify the user's color preferences.

Getting ready

Open any existing QlikView document with at least one listbox (perhaps one of the documents from Chapter 1, Charts).

How to do it

Follow these steps to change the default green, white, and gray color schemes:

  1. From the Tools menu, select Edit Module (or press Ctrl + M).

  2. Enter the following code:

    Sub SetColorPrefs()
    
      Dim UserPrefs
      
      set UserPrefs = _
        ActiveDocument.GetApplication.GetUserPreferences
    
      ' Set the "Selected" Color
      UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _
        RGB (0,0,255)    ' Blue
      UserPrefs.CustomSelFgColor(1).PrimaryCol.Col = _
        RGB (255,255,0)  ' Yellow
      ' Set the "Possible" Color
      UserPrefs.CustomSelBgColor(2).PrimaryCol.Col = _
        RGB (255,255,0)  ' Yellow...

Modifying the green, white, and gray selection color schemes in QlikView Server


In the previous recipe, Modifying the green, white, and gray selection color schemes, we used the API to modify a user's default color scheme. However, this is a user setting and doesn't automatically apply to QlikView Server.

In this recipe, we will take the setting generated in the last recipe and apply them manually to QlikView Server.

Getting ready

Complete the previous recipe, Modifying the green, white and gray selection color schemes.

How to do it…

These steps show you how to modify the green, white, and gray color scheme on QlikView Server:

  1. Locate your Settings.ini file in C:\Users\username\AppData\Roaming\QlikTech\QlikView.

  2. Open the file in Notepad and locate the CustSel entries. Select them all and copy them to the clipboard (Ctrl + C).

  3. On the QlikView Server, stop the QlikView Server Service.

  4. Locate the Settings.ini file in C:\ProgramData\QlikTech\QlikViewServer.

  5. Paste the CustSel values from the user Settings...

Using containers as an alternative to multiboxes


Multi Boxes have been around in QlikView for a long time. They can be a useful way of adding many selectors to the layout when there is little room for a lot of listboxes.

They can be presented either in the default, lateral mode, with the drop-down list across from the label, or in Grid Mode, with the drop-down list underneath the label.

I used Multi Boxes for many years and quite liked the Grid Mode style. However, there was a major problem. Unfortunately, the Grid Mode style is not supported in the AJAX ZFC web client.

Since Version 10 of QlikView, I have moved away from Multi Boxes and instead use a container control with listboxes. I believe that it is a much better way of accessing many fields in a small form factor.

Getting ready

Load the following script:

LOAD * INLINE [
    Country, Product, SalesPerson, Category, Sales
    USA, Widget, Joe, Widgets, 1234
    USA, Woggle, Joe, Widgets, 1983
    USA, Brogue, Jane, Footwear, 1175
    USA...

Using the design menus to custom format a cell


There are two design menus that can appear when you right-click an object on the layout. They are:

  • Order: This is applicable to all objects, and this menu has a submenu that allows you to adjust the Layer of an object.

  • Custom Format Cells: This is applicable only to the three grid objects (Table Box, Straight Table, and Pivot Table), and this menu allows you to apply your own custom color, border, and font options to a cell.

These menu items do not appear by default. There are two ways of making them available. You can either turn on the Design Grid option (from the View menu), or you can turn them on by changing your User Preferences, which we will do in this recipe.

Getting ready

Load the following script:

Load * Inline [
  Country, Sales, Costs
  USA, 1203, 1043
  UK, 987, 995
  France, 1118, 1022
  Germany, 876, 754
];

How to do it…

Use the following steps to custom format a cell in the table:

  1. Create a straight table with Country as dimension and...

Left arrow icon Right arrow icon

Key benefits

  • Learn beyond QlikView training
  • Discover QlikView Advanced GUI development, advanced scripting, complex data modelling issues, and much more
  • Accelerate the growth of your QlikView developer ability
  • Based on over 7 years' experience of QlikView development
  • Written in a handy Cookbook style with each recipe as a self-contained learning module

Description

QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access. QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions. Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise. From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about. The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.

Who is this book for?

This book is for anyone who has either attended QlikView Developer training or has taught themselves QlikView from books or online sources. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to!) and want to improve your QlikView skills.

What you will learn

  • Use QlikView charts to create more advanced visualizations
  • Layout your screen and use different color schemes
  • Get to grips with set analysis
  • Use Total and AGGR for advanced aggregations
  • Use macros to perform advanced tasks
  • Overcome data modelling challenges
  • Use some of the most useful functions in QlikView
  • Write great script
  • Improve the performance of your application
  • Secure your application

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jun 24, 2013
Length: 290 pages
Edition : 1st
Language : English
ISBN-13 : 9781782179733
Vendor :
Qlik
Category :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Jun 24, 2013
Length: 290 pages
Edition : 1st
Language : English
ISBN-13 : 9781782179733
Vendor :
Qlik
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 114.98
QlikView for Developers Cookbook
$48.99
QlikView 11 for Developers
$65.99
Total $ 114.98 Stars icon
Banner background image

Table of Contents

11 Chapters
Charts Chevron down icon Chevron up icon
Layout Chevron down icon Chevron up icon
Set Analysis Chevron down icon Chevron up icon
Advanced Aggregations Chevron down icon Chevron up icon
Advanced Coding Chevron down icon Chevron up icon
Data Modeling Chevron down icon Chevron up icon
Extensions Chevron down icon Chevron up icon
Useful Functions Chevron down icon Chevron up icon
Script Chevron down icon Chevron up icon
Improving Performance Chevron down icon Chevron up icon
Security Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4
(24 Ratings)
5 star 70.8%
4 star 12.5%
3 star 8.3%
2 star 4.2%
1 star 4.2%
Filter icon Filter
Top Reviews

Filter reviews by




gaurav babbar Jul 04, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Lots of tips and tricks which one can learn only after years of trades.
Amazon Verified review Amazon
O.T. Jul 29, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
"QlikView for Developers Cookbook" should find its prominent place on every serious QlikView developer's desk. This is a portable guide to many "secrets of trade" that have been mastered by a very creative QlikView practitioner, through years of developing advanced QlikView applications.While it's not a typical tutorial book that takes the reader from the basics to the advanced topics, the Cookbook offers hundreds of specific solutions, from curiously obscure to tremendously useful, and none are too obvious.Stephen Redmond, a brilliant QlikView practitioner, is showing his magic tricks, one after another, and unlike any other magicians, he immediately reveals to the audience how the trick works. The book is even structured this way. In each chapter, after the problem at hand is presented, the reader will find a section "Getting Ready", where each exercise is prepared with a simple load script and some initial configurations. Then, the next section "How to do it", shows the trick by walking the reader through the "magical" configuration or a setup that makes the trick work. Most training manuals stop there, assuming that the rest is obvious, - which is rarely the case. Stephen is going further by adding a section "How it works", which provides a nice explanation of the settings and the underlying logic that made the trick possible. Furthermore, when there is additional lesson to be learned, an additional section "There's more..." includes any additional related information. I found this form of explanation extremely educational - I don't just blindly learn HOW to do something, I'm also learning WHY should it work and WHAT ELSE do I need to know about it.As an experienced QlikView practitioner, I didn't expect to learn a lot of new stuff, and I was proven wrong. Many of the ideas in the Cookbook looked new and refreshing for me. I truly believe that every serious QlikView developer will find a lot of interesting insight in this book. I certainly did.Oleg Troyansky,President,Natural Synergies, Inc.
Amazon Verified review Amazon
Vassya Nov 03, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Amazing book, even for seasonal qv developer. It sets a certain baseline of skills and technics, which a developer should remember and use. All the most important aspects of script writing, data modeling, interface design are presented - almost nothing to add!
Amazon Verified review Amazon
Shilpan Jun 29, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I admire Stephen and regularly read his blog. His book didn't disappoint me either. Qlikview cookbook is full of practical recipes that you can apply in real world applications.This book is not for novice Qlikview developer. But, if you have some experience with Qlikview, I highly recommend that you buy this book because it will help you grow as a professional Qlikview developer.I have my own Qlikview blog as I am passionate about Qlikview development. I have written a very comprehensive review on my blog. So, if you are thinking about purchasing this book yet wanted to know more about its content, please visit my blog.[...]
Amazon Verified review Amazon
np Aug 07, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book is not for new learners but if you have couple of months experience this book gives lots of tips handling different thinks in qlikview.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.