How to write SQL stored procedures for Qlik

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!

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

Back door access to your Qlikview report

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.

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

A nice post I found over at BI Review


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

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:

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

How to connect to an SQL Server

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?