Setting Up Security Rules In Qlik Sense QMC
If your familiar with QlikView and move to the new Qlik Sense tool you’ll see a lot of similarities. The script, expression writing are the same. The QMC is very […]
Author Archives: Richard Pearce
QlikDevGroup and Me
For those who weren’t able to attend the QlikDevGroup event last night in London I have some very special and personal news. It’s with great pride I’m able to let […]
QlikDevGroup: Michael Bienstein – Upcoming Opportunities For Qlik Technologists
Hello, From the QlikDevGroup event in London on the 1st February 2016 In this video Michael Bienstein talks about Upcoming Opportunities For Qlik Technologists. Note: I’ve recorded the videos in […]
Automatically Create Point in Time Expressions
I come from an old school programing background which I think helps me write code that takes a process through step by step. This is known as ‘cursering’ through the […]
Scatter Plots are good
I was helping a customer recently when I was shown a Pie Chart they had developed in QlikSense showing product returns, they liked the chart although they asked how they […]
Error Trap
If at first you don’t succeed, Error Trap! Sometimes things go wrong…. Sometimes if you wait a few seconds and try again it works. Strange but true! Here we look […]
Cumulative Values In the Script Using Peek()
Everyone loves cumulative values on a chart and they’re are possible with an expression using the above function. This shows you how to add them to the data table in […]
The Problem with Where Not Exists
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 […]
Fixing Set Analysis in Qlik
Set Analysis is a very powerful tool in Qlik, put simply it allows you to pre-define selections on an expression. Typically your first type of set analysis will be simple, such as […]
Think Before You Link
Qlik is all about the data, get that right and your visualisations will be effortless! I typically bring all my data together into a Star Schema and I’ve written a […]
qlikcentral 