Generational Differences in Working Styles

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.

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.

Section access - part one (including inline wizard)

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.

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.

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.

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