qlikcentral

Understand / Create / Inform

Main Menu

Skip to content
  • About Me
  • Code Examples
  • Qlik Brain Teasers
  • QV Blogs I Like
  • Interview Questions and Hints

Category Archives: Create

Left Join

Joins, Concatenation and the Applymap function

August 26, 2014by Richard Pearce 11 Comments

When you first start using QlikView (and this applies to the start of a new project) your data structure will probably be a simple snowflake schema where data is loaded […]

Read Article →
Create, Scripting
Battenberg

The Optimal QlikView Data Structure

August 19, 2014by Richard Pearce 8 Comments

It doesn’t take long to discover that organising your data correctly within QlikView is the secret to success. A couple of well known phrases always spring to mind: The 80 […]

Read Article →
Best Practice, Create, Scripting
Importing Colours into QlikView

Importing Colours into Variables

July 8, 2014by Richard Pearce 1 Comment

Hi, Here is my very first video. I plan to run several covering the basics of flat design in QlikView. This video covers loading a flay colour scheme into variables […]

Read Article →
Create, Design and Layout, Flat Design, Scripting, Video Tutorial
Who are QlikView Developers?

Who are QlikView Developers?

June 22, 2014by Richard Pearce 2 Comments

QlikView Developers are often lumped into a general ‘IT’ category. I myself take great personal delight in the fact friends and family don’t know what my role as a QlikView […]

Read Article →
Create, Design and Layout, Inform, Understand
DatesToLoad

Loading Multiple QVD files

June 2, 2014by Richard Pearce 2 Comments

Hi, all of my Qlik applications have QVD data staged and prepared in advance. Here I will go through how I import them efficiently into QlikView. For now I’ll assume […]

Read Article →
Create, Scripting
Fun With Flags

Calendar with flags making set analysis so very simple

May 16, 2014by Richard Pearce 8 Comments

Hello, Calendars are one of the first things developed when working with Qlik and most follow a similar format. Often called “Master Calendar” the name misleads as best practice design […]

Read Article →
Create, Scripting
Importing Colours into QlikView

Painting Space and Reference Lines

April 30, 2014by Richard Pearce Leave a comment

Using offset can do more than simply create waterfall charts. Recently I’ve seen a number of questions relating to Painting Space in a line chart and also how to add […]

Read Article →
Create, Design and Layout, Inform
Data Input

InputField Update Macro

April 14, 2014by Richard Pearce Leave a comment

Recently I’ve been having great fun with input fields. For those of you not aware (which was me only a month or two ago) Input fields behave somewhat differently from […]

Read Article →
Create
QlikView Storing Expression in Variables

Table Analyser

April 2, 2014by Richard Pearce Leave a comment

Before development can begin you need to know your data. Whilst working on a contract a number of years ago I created an application that may help. Be warned it can […]

Read Article →
Create, Understand
waterfall

Waterfall Charts

March 26, 2014by Richard Pearce Leave a comment

Waterfall charts are a very effective way to display information. Recently, I required one with a drill down group which caused challenges with the bar offset. Here is a link […]

Read Article →
Create, Inform

Post navigation

← Previous 1 2 3 Next →

Enter your email address to follow this site and receive notifications of new posts by email.

Tags

Analyse analysts Best Practice calendar Certification Change Control Chart Colour Dashboard data debug debugging design Designer Developer expression Extensions Flat Design Henric Cronström Joining Data layout Loading Data Looping Q2018Talk Qlik QlikDevGroup Qlik Sense QlikSense QlikView QlikView Engine QVD requirements script Selections Storing Structure Testing variables Version Control youtube

Top Posts & Pages

  • Section Access Reduction in Qlik Sense
  • Stop storing your Qlik Sense Expressions in Variables!
  • Setting Up Security Rules In Qlik Sense QMC
  • The Problem with Where Not Exists
  • Code Examples
  • FirstSortedValue
  • Qlik Sense Data Model and Field Naming
  • Why Bother With Qlik Extensions
  • Requirements Gathering
  • Loading Multiple QVD files

Archives

Blogroll

Meta

  • Register
  • Log in

Richard Pearce

Richard Pearce

Qlik Expert | Qlik Luminary 2017, 2018 and 2019 | Qlik Speaker

About the Author: Richard Pearce

Richard has been working within Business Intelligence for over 20 years. He has managed teams of analysts in a number of large organisations across finance, healthcare, service, and retail. He has worked extensively with QlikView and Qlik Sense. He is a Director of the QlikDevGroup, a meetup captain, a Qlik Luminary and speaks at many Qlik events around the world

  • About Me
  • Code Examples
  • Qlik Brain Teasers
  • QV Blogs I Like
  • Interview Questions and Hints

©2019 – Richard Pearce
Please contact me if you’re concerned about any accidental infringement for immediate removal.

Blog at WordPress.com.
  • Follow Following
    • qlikcentral
    • Join 251 other followers
    • Already have a WordPress.com account? Log in now.
    • qlikcentral
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Our Cookie Policy