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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIxeDi-aB0wLHGXLQJHdRrLv_ujhcd2ifDBZy4kcJCDP9TgUe0cvGRlndNpXwwc2l35cmw9i0saMa92yRm3RgA5BXiZXfTkV-aURKbw0sJ3n07DgDG-5fkQvPTPzie_cAwWdzQsP6-uROn/s400/2016-10-02_13-05-54.png)
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)