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.
One Qlik at a Time
Half guides, half a repository of my Qlikview knowledge. A smattering of links to other cool Qlikview stuff.
Monday, 24 October 2016
Generational Differences in Working Styles
Labels:
Data,
Opinion,
Qlikview,
visualisation,
visualization
Sunday, 2 October 2016
Making Awesome Qlik Sense Date Dropdowns
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...
Here's how to get that lovely drop down expanding from all your date fields that you see in all the Qlik demoes...
Labels:
Business Intelligence,
Intermediate,
Link,
Mapping,
Qlik,
QlikSense,
Script
Location:
United Kingdom
Monday, 16 May 2016
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!
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!
Labels:
Advanced,
Basic,
Connection,
Data,
Intermediate,
Load,
QlikSense,
Qlikview,
Script,
Tables
Thursday, 26 November 2015
Dealing with Salesforce Periods in Qlikview
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
--However reporting on Forecasts with actual amounts turns into a bit of a nightmare, see below for how I've started puzzling this out
Labels:
Advanced,
Business Intelligence,
Dates,
Design,
Qlikview,
Resident Load,
Salesforce,
Script
Thursday, 9 July 2015
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
I've created a useful dashboard that allows monitoring of the SQL reporting execution logs.
Edit: now including screenshots of what's included
Labels:
Business Intelligence,
Charts,
Connection,
Data,
Dates,
Design,
Multi Box,
Qlikview,
Resident Load,
Script,
SQL,
SSRS,
Tables
Wednesday, 31 December 2014
Quick SQL Reporting - processes and blocking
A quick Qlikview/SQL script to process monitoring - in place of using SP_WHO2
Monday, 29 December 2014
T-SQL Database Explorer Script
Dynamic SQL script to query all objects within a SQL instance for use in Qlikview.
Subscribe to:
Posts (Atom)