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.
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
Subscribe to:
Posts (Atom)