Load Script



Free Qlik Web Connectors

Quick Intelligence were long standing partners of Industrial Codebox and re-sellers of their QVSource product. At Qonnections this year it was announced that ICB were being purchased by Qlik. This month QVSource re-launched under the name Qlik Web Connectors, with a number of free ‘Standard’ connectors. In this post I look at some of what you can do with this product without licencing premium connectors. […]

By | 2017-07-17T12:17:58+00:00 July 26th, 2016|Announcements, Load Script, Qlik Sense|13 Comments

Variables With Parameters In Qlik Load Scripts

The implementation of variables and dollar sign expansion in QlikView and Qlik Sense is incredibly flexible and can be used to great effect in load scripts. In this post I show how and give a recipe for a NetworkDays function that excludes public holidays. […]

Hidden QlikView Features

Recently I blogged on Include Files in QlikView, and mentioned the fact that QlikView doesn’t advise you when an include file was missing.  This led to a discussion on QlikCommunity and a revelation to me of a new feature.  This feature is not documented in the QlikView help files and Google turned up just one result for it. […]

By | 2015-11-09T09:53:49+00:00 April 2nd, 2013|Load Script, QlikView Tutorial|25 Comments

QlikView Include Files

When developing QlikView apps it is a good idea to develop standards that you adopt across all of your documents. A good way of ensuring these standards are followed is to use Include files in your load scripts. QlikView Include files are snippets of code that are stored as text files outside of the QlikView app. Use of includes across multiple apps allows for effective code reuse. […]

By | 2013-04-03T11:40:28+00:00 February 27th, 2013|Load Script, QlikView Tutorial|14 Comments

QlikView Optimised QVD Loads

In previous articles I have mentioned how critical it is to ensure your loads from QVD are optimised, but have not gone into the detail of how to do this. This post rectifies that.  Here I explain what an optimised load is, why you should use them and how to perform them. […]

By | 2016-06-25T01:45:28+00:00 February 20th, 2013|Load Script, QlikView Tutorial|34 Comments

QlikView Incremental Load

Analysis in QlikView is lightening quick, millions of rows can be aggregated and manipulated with very little latency.  Getting those millions of records off a server elsewhere on your network – now that can be a different matter.  This is where a robust QVD strategy and QlikView Incremental Loads become crucial. […]

By | 2018-04-23T09:42:56+00:00 January 24th, 2013|Load Script, QlikView Tutorial|67 Comments

Perfect Your QlikView Data Model

Recently I blogged on the pitfalls of not investing sufficient effort at the start of a QlikView project to avoid problems later on (see the post Start Your QlikView Project The Right Way).  In this article I advised that the single most significant factor in whether a QlikView project is a success is a well designed data model.  Here I would like to share some of my suggestions for getting the data model right, as this could save you a lot of pain if you are just about to build a QlikView Document or indeed a whole environment. […]

By | 2016-06-25T01:47:40+00:00 December 3rd, 2011|Load Script, QlikView Tutorial|56 Comments

Start Your QlikView Project The Right Way

As a freelance QlikView consultant I can be drafted in at any stage of a QlikView implementation.  My favourite sites tend to be the ones where I come in and do the initial demo to the client (not least because I love seeing the moment when jaws drop in the demo) and then build the solution from the ground up.  Often though I am called in where a lot of effort has been expended already but things have got to a sticking point and someone decides expert help is required. […]

By | 2016-09-16T21:22:49+00:00 November 20th, 2011|Load Script, QlikView Tutorial|12 Comments