Load Script

Change to Qlik SaaS Licences API Endpoint

There is a massive amount of information that can be loaded directly into your Sense apps from the Qlik Cloud API. If you have been loading from the Licences endpoint though you may have noticed a change to the response since yesterday. The userId and name fields in the response have now been replaced with subject, potentially breaking your script. […]

By |2023-09-14T09:20:46+00:00September 14th, 2023|Instant App, Load Script|3 Comments

Compare Rolling Twelve Month Period in Qlik

Creating a line chart in Qlik showing a year on year comparison is very easy, using the Month and Year functions to create two dimensions. What if you want to show a rolling twelve month comparison though? This is not quite so obvious, but this post makes it just as easy. […]

By |2023-05-05T11:12:11+00:00May 5th, 2023|Load Script, Qlik Sense Tutorials|2 Comments

Loading Data from Online CSV Sources into Qlik

There are myriad different data sources out there, and it is possible to load any of them into Qlik. Some are easier than others, sure, but there is always a way. There are good articles and posts on some of the trickier sources, but today I want to show you how you can bring in CSV data from GitHub. This means you can pull up to date, crowdsourced and governed data directly into your applications, just by following these simple steps. […]

By |2023-02-26T16:48:41+00:00January 8th, 2021|Instant App, Load Script, Qlik Sense Tutorials|0 Comments

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 |2023-04-16T19:23:16+00:00July 26th, 2016|Announcements, Load Script, Qlik Sense|23 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. […]

How To Read Meta Data From A QlikView QVD

QVD files are the backbone of any well designed QlikView application.  You store your data in there and read it out again – simple.  But, did you know that the QVD header holds some useful meta-data?  Did you know that could be loaded into QlikView for analysis?  No?  Well, read on. […]

Accumulate Values in the Qlik Load Script

When there is a need to count the same value against a number of dimension QlikView provides a number of ways of achieving this. Not all of them work entirely as you would like. This simple data model approach provides another way. […]

By |2023-04-22T11:25:52+00:00April 21st, 2014|Load Script, QlikView Tutorial|18 Comments

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:00April 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:00February 27th, 2013|Load Script, QlikView Tutorial|14 Comments
Go to Top