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!

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

Quick SQL Reporting - processes and blocking

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

T-SQL Database Explorer Script

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

Hello Qlikview!

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.

10 Reasons you should try out Qlikview

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

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?