One Qlik at a Time

Generational Differences in Working Styles

2016-10-24T11:45:00.000+01:00

Hi, I'm working on something new at the moment and if you have two minutes it would be great if you could lend a hand.

Read more »

Making Awesome Qlik Sense Date Dropdowns

2016-10-02T13:28:00.001+01:00

One of my favourite things in Qlik Sense is the new calendar function, however talking with other developers I've found that some people don't know about them yet.

Here's how to get that lovely drop down expanding from all your date fields that you see in all the Qlik demoes...

Read more »

How to write SQL stored procedures for Qlik

2016-05-16T18:30:00.000+01:00

Recently I wanted to add one of my stored procedures for a different report into a dashboard to show the power of Sense (integrating pre system data with the new ERP system, Awesome!)

However, whatever I did, my stored procedure wouldn't run in Qlik Sense... so I did what I usually do in this situation and ran back to Qlikview to see if I could identify the problem and I couldn't! I should point out that this code was live and running fine in both SQL and crystal reports (a necessary evil for other projects!)

TL;DR version: the SP layout is at the end of the article!

Read more »

Dealing with Salesforce Periods in Qlikview

2015-11-26T20:00:00.000+00:00

SalesForce is brilliant and reporting on it in Qlikview is really easy with the Qlikview SalesForce Connector.

--However reporting on Forecasts with actual amounts turns into a bit of a nightmare, see below for how I've started puzzling this out

Read more »

SQL Report Server OPS monitor

2015-07-09T18:00:00.000+01:00

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

Read more »

Quick SQL Reporting - processes and blocking

2014-12-31T12:41:00.000+00:00

A quick Qlikview/SQL script to process monitoring - in place of using SP_WHO2

Read more »

T-SQL Database Explorer Script

2014-12-29T13:28:00.001+00:00

Dynamic SQL script to query all objects within a SQL instance for use in Qlikview.

Read more »

Painting with Colours Part 1

2013-05-27T21:26:00.003+01:00

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.

Read more »

Section access - part one (including inline wizard)

2012-07-16T20:05:00.000+01:00

So you have written your first few reports, your company has gone wild for Qlikview and know it's time to think about how you're going to implement security on your reports.

This is the first of two parts on section access, Section Access is how Qlikview restricts data based upon your login.

Read more »

Qlikview Charts with Colours

2012-07-02T22:10:00.000+01:00

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...

Read more »

Back door access to your Qlikview report

2012-06-19T20:05:00.000+01:00

So you're working on a Qlikview document and then the next day you can't open it

We've all been there, maybe you're playing around with the relationships in your data. Saved your work and then you open it and the charts trying to generate crashes your pc.
Or maybe you’ve been working on a report all day, got your data right and take it home to make your charts and your laptop hasn’t picked up a license from the server before you left.

Here’s a couple of ways you can save your reports and a quick note on limiting other people’s access to your data.
Read more »

Quick Region Maps

2012-06-12T20:45:00.002+01:00

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.
Read more »

Hello Qlikview!

2012-06-01T11:05:00.003+01:00

Hello Qlikview!

I'm currently reading through this book, it's aimed as an introduction to Qlikview for complete novices and has got some nice examples so far.

I'll be posting a full review once I have finished it.

Sometimes it's so simple it's too obvious - drawing circles in Qlikview

2012-05-24T20:03:00.000+01:00

A nice post I found over at BI Review

BI Review: How to draw circles and ellipses in QlikView:

In Statements in Qlikview - Match()

2012-05-12T12:51:00.000+01:00

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:

Read more »

10 Reasons you should try out Qlikview

2012-05-08T20:13:00.000+01:00

“Qlikview is great, all hail our wondrous shiny BI tool…” is the shout of Qlikview resellers everywhere, in this post I’m going to tell you why I think you should give it a try.

Qlikview isn’t perfect by any means, but here are some of the reasons that we first trialled it and then signed up.

A Quick Post - Exporting Current Selections with your data

2012-05-06T11:04:00.002+01:00

I just came across this article and will be looking into it more in the future, as I have been asked multiple times on export if we can include the current selections.

I have a macro work around but it's quite clunky, this looks much more elegant

QlikTip #1: Transferring Current Selections to Excel-Export (translated)

Cooking with Qlikview Variables

2012-05-04T23:42:00.001+01:00

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...

Read more »

QlikView Scripts in Notepad++

2012-04-30T21:34:00.001+01:00

Just a quick post: As a heavy user of notepad++ for SQL I think this is a great idea and will be trying this out in the near future and will give my feedback

QlikView Addict: QlikView Scripts in Notepad++:

'via Blog this'

Checking your data made it

2012-04-29T22:39:00.000+01:00

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..

How to connect to an SQL Server

2012-04-28T17:16:00.001+01:00

So my first post on the all new blog, I'm by no means a Qlikview expert but I have been using it for two years now and can find my way around.

What I'm hoping to do with this blog is compile a list of how to do everything in Qlikview, starting right at the beginning.

The qlikview training is great, however Qliktech seems very focussed on using files as a datasource. I know the first question I asked after completing the tutorial was, how do I connect to a database?