qlikcentral

Understand / Create / Inform

Main Menu

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

Tag Archives: data

Where Not Exists

The Problem with Where Not Exists

January 21, 2016by Richard Pearce Leave a comment

Do you know what the problem is? I use Where Not Exists all the time, typically when I’m incremental loading. (a detailed video of how to do that can be […]

Read Article →
Best Practice, Creating an Incremental Load Script, Scripting, Video Tutorial
QlikView Set Analysis

How does Set Analysis Work in QlikView

June 17, 2015by Richard Pearce 2 Comments

Hi In previous posts I’ve talked about the QlikView Engine Explaining Symbol and Data tables and how QlikView understand Selections using the Logical Inference Here we will be taking the concept […]

Read Article →
Create, Inform, Understand
QlikView Symbol Table Selections

Selections and Logical Inference

June 15, 2015by Richard Pearce 2 Comments

Hi In a previous post I talked about the QlikView Engine and Explained Symbol and Data tables……. When selections are made on a QlikView dashboard you see the Green, Grey and White […]

Read Article →
Create, Understand
The Qlik Engine

The QlikView Engine

June 8, 2015by Richard Pearce 4 Comments

Hi everyone, Understanding how the QlikView engine stores and processes the data really helps you create efficient QlikView dashboards. Understandably a Qlik developer never needs to know all the detail of […]

Read Article →
Data Load, Scripting, Understand
Fun With Flags

Flag Latest Record using QlikView Script

September 1, 2014by Richard Pearce 6 Comments

Often you’ll have a number of records for effectively the same thing and you’re only interested in the latest one. For example each day you count widgets and the customer […]

Read Article →
Create, Scripting
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
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
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

Post navigation

Categories

  • Best Practice
  • Create
  • Data Load
  • Design and Layout
  • Extensions
    • D3
      • JavaScript
  • Flat Design
  • Inform
  • Just for Fun
  • mashup
  • News / Updates
  • Projects
    • As Of Calendar
  • QMC
  • Scripting
  • Understand
    • Certification
  • Video Tutorial
    • Creating an Incremental Load Script
  • November 2022
  • July 2022
  • May 2022
  • September 2021
  • November 2020
  • August 2020
  • May 2019
  • April 2019
  • November 2018
  • October 2018
  • September 2018
  • July 2018
  • February 2018
  • January 2018
  • May 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • April 2012

Top Posts & Pages

  • Test! Don't Assume
  • Section Access Reduction in Qlik Sense
  • Stop storing your Qlik Sense Expressions in Variables!
  • Requirements Gathering
  • FirstSortedValue
  • Setting Up Security Rules In Qlik Sense QMC
  • Why Bother With Qlik Extensions
  • Documentation
  • Toggle Between Mashup Charts
  • Should I link or Concatenate

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

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