Fabian

51 Flips | 1 Magazine | 1 Like | 67 Followers | @Fabster79 | Keep up with Fabian on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Fabian”

Crime and employment - Color as a trend

I was playing around with Qlik Cloud again. I grabbed some data from the Irish Central Statistics Office on employment statistics in Ireland and …

A Color Trick

A Customer showed me this stacked bar chart and asked how to "make the Goals a different color". What he really wanted was to differentiate the Goal …

Generate and execute a batch file in QlikView

My good friend and fellow Irishman, Alan Farrell, pinged me on Twitter this evening with this question: "can you create a .bat file in qlikview and …

Linked bar charts

Two questions from business users that will probably sound familiar to most QlikView Developers:<p><i>“We currently use this report. Can you re-make this</i> …

Is QlikView v11 vs. QlikView.Next the right question?

I have seen and heard a lot of discussion about what is missing from the initial beta release of QlikView.next as compared with QlikView v11. I am …

Qlik Design Blog

I was asked recently if I could produce a standard control chart or SPC chart in QlikView. So I thought I would share this on the blog.<p>SPC and …

QlikView Open Data Challenge Winners

There is a wealth of freely available information on the internet now. What if some of these data could be put to good use? QlikTech put out a …

SlopeGraph for QlikView (D3SlopeGraph QlikView Extension)

Some weeks ago the chart type “Slope Graph”, invented by Eward Tufte in 1983, was first brought to my attention.<p>When I first saw it I thought that it …

QlikView Functions: autonumber()

Having our new baby (AKA the mini QlikView addict) around has meant very little time for anything, let alone blogging. So in order to ensure I at …

Move Items Within A QlikView Chart Object

This series of posts is designed to capture the things that I do all the time when building QlikView apps that may not be so obvious to others. This …

Bucket analysis by copying states

Alternate States were introduced in QlikView 11. This allows different objects to be in different selection states.<p>You can have, for example, 2 list …

QlikView Scripting Book Now Available

Many of you will know that Packt Publishing have a number of excellent QlikView books to their name. Barry Harmsen and Miguel Garcia’s excellent …

Perfect Probability Pipeline

The way I see it, if you're gonna build a time machine into a car, why not do it with some style? The 1981 DeLorean DMC-12 had it all - a weak V6, …

Industry Insights - Axis Group - Data Solutions for Business

Axis Group is the leader in optimizing business through data: Data Strategy. App Development. Operations. Read our latest BI blog.

Executive Dashboard: Combining Multiple QlikView Documents into a Single Dashboard

This article demonstrates how you can combine several objects from multiple QlikView applications into a single dashboard (Executive …

Highlighting Redux – Alternate States to the Rescue!

The year was 2010 … Katy Perry and Lady Gaga topped the charts. Gas was $4.00 a gallon. A beer in Los Angeles cost five bucks. And dynamic …

The one that got away - linking Section Access to multiple dimensions

During the writing of QlikView for Developer's Cookbook, I added a new recipe quite late on but, for one reason or another, it never made it into the …

QlikView Notepad++ Language Definition v2.1

Notepad++ version 6.4.1 was released recently and contains some exciting new additions.Top of the list is the new function list which has been …

DISTINCT can be deceiving

Never think you know it all! Today I have for you a little ‘gotcha!’ about the LOAD DISTINCT statement that I picked up from Oleg Troyansky at the …

QlikView for Developers Cookbook + Foreword

As you may have read or seen elsewhere already, the 24th of June saw a new addition to the QlikView library; Stephen Redmond‘s QlikView for …

Improved WebPageViewer QlikView Extension (WebPageViewer2)

The “WebPageViewer” extension which will be installed with the QlikView installation (C:\Program …

Bricks on maps instead of circles

In his recent newsletter, Stephen Few introduces the concept of using bricks as "A New, More Perceptible Method for Encoding Quantitative Values in …

REBOOT! an awesome trick to simulate OnOpen

Do you use OnOpen triggers in your application? Isn’t it a pain to have close and then re-open the app to test them?I accidentally happened across a …

Painting with Colours Part 1

Hello, and welcome back to One Qlik at a Time after a long hiatus.<br>Recently I've been playing with colours and I'm going to do a quick two part guide …

User friendly field names in QlikView

I spent a day last week working with a customer planning some improvements to their solution and taught them a few little tricks on the way. One tip …

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 …

WHEN and UNLESS

No, this post isn’t about that negative co-worker or friend who’s always second-guessing your ideas and solutions, it’s about two QlikView script …

Creating a mobile Dashboard for the Iphone

<b>Mobile BI</b> is a key issue when it comes to Business Intelligence trends. When developing a QlikView App, it can be opened on a mobile device, without having to use an extra App or without having to do extra development! I think that is great!<p>But when doing a lot of QlikView implementations out there in the field, you will be facing some pitfalls that might dampen your enthusiasm.<br>For me, that is especially the scaling behavior of QlikView, which is somewhat not predictive from my point of view. …