SQL Report Server OPS monitor

Time for something completely different, I'm of the opinion that whilst Qlikview is great for dash-boarding, sometimes having a SQL reporting server gives you functionality that can be useful.

I've created a useful dashboard that allows monitoring of the SQL reporting execution logs.


Edit: now including screenshots of what's included

Painting with Colours Part 1

Hello, and welcome back to One Qlik at a Time after a long hiatus.

Recently I've been playing with colours and I'm going to do a quick two part guide on how to change colours quickly and easily in your Qlikview docs. Starting right from scratch today and moving onto best practices in the next post.

Part 1 (Basic)

1. Changing colours on a chart
2. Applying colour defaults
3. Quickly change colours

Part 2 (Intermediate)

1. Defining colours with variables
2. Defining colours within the load script
3. User Defined Colours with triggers

Now let's get cracking, first you'll need to download my latest Qlikview so that you can follow along with the steps.  

Qlikview Charts with Colours

Matt over at Qlikview Addict, recently posted about how to create Gantt Charts in Qlikview.


Here's my quick post about how I customized my Gantt chart to colour my chart based off dates and adding a couple more data guidelines.  Please note that you will need to follow the original article before starting this...

Quick Region Maps

So you need to map out your data but you either

• Don’t have database access
• Want to define your regions as per your client's request
•  NEED IT DONE YESTERDAY

If you have a postcode (or Zipcode) Don’t sweat, I have you covered with this Qlikview demo.  It’s ready to go in five minutes for UK readers and everyone else should be able to convert it in less than an hour.

In Statements in Qlikview - Match()

I don't know about everyone else but I have often googled for how to do an in statement in Qlikview.


#Note by an In statement I am referring to how to test one value against multiple values or a range of values


As searching for the word "in" in relation to Qlikvew is nigh on impossible here's a quick post explaining how to do it and how to use it for custom sort lists:

Cooking with Qlikview Variables

So it's six days since my first post and here we are at 350 views!


I was originally planning to cover something more basic in this post but I had an idea earlier on this week that I thought would be a cool demo and after trying things out I think I have it.


This post is called "Cooking with Qlikview Variables", I will be using variables input on screen in order to generate data that is then used within the Qlikview document itself...

Checking your data made it

So from my previous post, we know how to get data from an SQL database into our Qlikview document.

Today I'm going to cover how to quickly check that your data has made it into Qlikview in the state you wanted it in..