Browsing:

Category: Qlik Sense

Using Sub Routines in Qlik

Using subroutines in Qlik is easier than you would think. Subroutines can be setup to call various parts of script in different orders than it would normally run. In all my training sessions i explain that Qlik runs from top Read more…


Data is Everywhere!

Data is everywhere and affects our very day to day life. At the Qlik Tour I presented at in July I went through statistics from Qlik that by 2025 its estimated that every single person will be making around 5000 Read more…


Connecting Qlik Sense to an API

Qlik Sense has a range of different connection options. This is one of the main strong suits of the products. As you can see from the visual below, there are a range of built in connections that are included as Read more…


Football is back, and so is my transfer dashboard

The football transfer window is closed and the 2019-20 season is underway, so I have updated my football transfer dashboard. As Qlik can pull data from multiple sources, I have scraped data back for the last 11 years and collated Read more…


Creating an Incremental Load in Qlik

Incremental loads create a much more efficient way of extracting and storing data in Qlik. If you have a large volume of data that does not change over time, it does not make sense to extract all of it every Read more…


Section Access Security

There are a few different use cases for section access. Section access is essentially the ability to restrict the level of data passed out to your front end users. It is the bouncer on the door. If your names not Read more…


Loops in the Script

Sometimes a straight forward load script will just not do the job!   What happens if you want to take multiple data sources from one or more locations, pull them into the same place and apply the same logic to Read more…


The Aggregate Function

The Aggregate function (AGGR) is a great function to use in dashboards in the right circumstances. Often when starting to use this function, the difficulty lies with the inability to visualise what the function is actually doing behind the scenes. Read more…


Advanced Set Analysis

My last post concentrated on users starting off with Set Analysis. As a recap, set analysis allows users to create a different selection than the active Qlik state by defining an alternative set of records within the set expression. It’s Read more…


Starting With Set Analysis in Qlik

I remember my first days working with QlikView with fond memories, however in the first few days the thing I struggled with the most was the set analysis. All the brackets! For a lot of new developers, set analysis can Read more…