Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.
adamcooke@webofwork.com

Tags

Qlik Load Script

Webofwork > Qlik Load Script

Hello! This is a file I created by scraping data from a freely available Geographical API. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every uk postcode. It also includes the Easting, Northing, Grid Reference, District, Ward, District Code, Ward Code and Country.   You can use this file in a tool like Qlik Sense to make fancy maps like...

Read More

Sometimes you may have some data that you want to store just within the load script and not have a completely separate data source. You can use an inline table to do this:   TableName: Load * inline [ Month,Quarter 1,Q1 2,Q1 3,Q1 4,Q2 5,Q2 6,Q2 7,Q3 8,Q3 9,Q3 10,Q4 11,Q4 12,Q4 ];   As you can see the fields are comma seperated. This goes directly in the load script and will show up as a new table called 'TableName' in your table viewer. You...

Read More

Datamarket is an attempt to give you access to reliable external data such as Weather, Demographics to provide insight with your own data set. Practically it means that once you go through the datamarket wizard, it will generate a Load statement that will pull the data you specified into your data model. By default the script will be locked - so it is controlled by the wizard,...

Read More

Subfield() is a great function for splitting a long string into seperate fields. You can use this to split out a date or anything where you have a common delimeter in a string. For example. If you have the string field name: TextString line 1: Big_Frogs_Are_Yummy You may want to split this out into 4 seperate fields. subfield(TextString, '_', 1) as FirstWord, subfield(TextString, '_', 2) as SecondWord, subfield(TextString, '_', 3) as ThirdWord, In...

Read More

Before we start please note the below is my own opinion and is in no way endorsed by Qlik as a company. Follow at your own risk :). The aim of this post is to explore the possibility of hosting a Qlik Sense mashup on the popular cloud web hosting provider Heroku. What is Heroku? Heroku (pronounced her-OH-koo) is a cloud application platform – a new way of...

Read More