Category Archives: General

General topics

Mobile BI survey

Mobile BI Survey

Calling the QlikCommunity! Help out a student with the research for his Master thesis and in return get some interesting insights into the benefits and capabilities of Mobile Business Intelligence.

Twan Peters is a graduate student at Tilburg University in The Netherlands. To earn his Master degree, he is conducting research into Mobile Business Intelligence. His research aims to measure mobile BI success by examining the net benefits and the related mobile BI capabilities. read more »

Using QlikView with the Leap Motion Controller

QlikView and Leap Motion? Shut up and take my money!In May of last year I became aware of a new and, dare I say, revolutionary 3D gesture controller; the Leap Motion. After seeing the slick video, I knew I had to have one, how cool would it be to use this with QlikView?

Unfortunately, these units weren’t for sale yet. And to be honest, this looked like another cool gadget that gets hyped for two weeks before, for whatever reason, fading back into obscurity. Noticing Leap had a Developers Wanted page, I figured “why not” and signed up, not expecting to hear anything after that.

read more »

Most popular posts of 2012 & plans for 2013

QlikFix: Best of 2012It’s that time of the year again where we take a look back at the past year and make plans for the new year. I hope you can look back at a successful year and have many exciting plans for the future.

For me, it’s been an intense but very fulfilling year, culminating in the release of the QlikView 11 for Developers book. I look forward to a new year filled with great opportunities and developments.

The QlikFix blog has been doing very well in the past year. 2012 brought roughly 50% more traffic than 2011 and the trend is moving upward. In this post I will share with you this year’s top 5 best read articles, and also request your input in shaping my plans for the blog in 2013.

read more »

Visual FX in QlikView (4): Season’s greetings!

Christmas time is coming near and I’m in a festive mood, so today I have a short post to wish you all a Merry Christmas and a Happy New Year!

Of course, it wouldn’t be a QlikFix Christmas if I hadn’t whipped up a little visual effect in QlikView. Without further ado, here is my QlikView Christmas card to you:

But wait, there’s more! Inspired by the Christmas theme over at Matt Fryer’s QlikView Addict blog (a recommended read, by the way), I decided to create a small document extension that lets you add a little Christmas spirit to your own QlikView documents. Amaze (or annoy) your clients, co-workers and users! For example, how about adding a little snow to the golf course?
read more »

How QlikView helped me fix QlikView

Fixing QlikView using QlikViewToday, instead of a tip, I have a little anecdote about how QlikView helped me fix QlikView.

One project had me setting up a customized QlikView Server environment for an enterprise client. Part of the customization was ensuring that the service accounts, the ‘users’ that are used to run the QlikView services, do not require local administrator privileges.

Anyone who’s had to deal with this requirement knows that it isn’t exactly a straightforward job. Out of the box, the QlikView services will not work without local admin privileges. There is some help, but on a typical ‘hardened‘ version of Windows Server you still need to do additional troubleshooting to make things work.

read more »

Announcing QlikView 11 for Developers: The Book

QlikView 11 for Developers book coverAfter many months of hard work, today I am proud and excited to announce the upcoming release of the new QlikView book that Mike García and I wrote together:

QlikView 11 for Developers

With 500 pages of original content and an extensive collection of code samples, we believe this book contains everything new (and seasoned) QlikView developers should know in order to put QlikView 11 to productive use.

The book will be published by Packt Publishing and is scheduled for release on November 15th. If you want to secure a copy for yourself, pre-orders can be placed via this page.

Of course, writing a book is not a solo (or in our case, duo) exercise. Mike and I could not have done it without the great contributions of:

Donald Farmer Foreword Blog @donalddotfarmer
Ralf Becher Technical review Blog @TIQView
Steve Dark Technical review Blog @quintelligence
Stephen Redmond Technical review Blog @stephencredmond
John Trigg Code support @qt_trigjoh
Rashmi Phadnis Acquisition editor @rashp
Joanne Fitzpatrick Acquisition editor
Sai Gamare Project coordinator @saigamare
Anugya Khurana Project coordinator
Ankita Shashi Lead Technical editor
Nitee Shetty Technical editor

In the coming weeks, we will be giving you insights into the book and will also be giving away a few copies, so be sure to watch this space. You can get notified of new posts by entering your email address in the input box in the top right corner of this page.

Update 2012/11/20: yesterday we were informed by the publisher that both the print version and the e-book will be released on November 23rd.

Update 2012/11/23: the book is now available for sale! (Amazon | Barnes & Noble | Packt)

Update 2012/11/29: for those that are unable to download the code bundle from the publisher’s website, you can also download it from this link: http://bit.ly/CodeBundle

QlikView Easter Egg

At least, I hope it´s a sense of humor, and not a new feature for QlikView.Next :)

A fun little easter egg that shows the boys and girls at QlikView R&D have a sense of humor. Entering the expression:

=’qmem://<bundled>/Images/clippy.png’

into a text object and choosing the Image representation shows our old *ahem* friend Clippy. Or should I say Qlikky?

Besides Clippy, there are actually a lot more images embedded in QlikView than just those listed under <bundled>/BuiltIn. Almost all of the images in the QlikView user interface (and lots more) can be referenced via the hidden folder <bundled>/Images. In the application that you can download below, you will find an overview of all hidden embedded images.

Download the QlikView hidden embedded images application

Update 2013/03/27: an awesome easter egg that I seem to have missed (because it’s a JPG instead of a PNG):

=’qmem://<bundled>/DevTeam.jpg’

This shows a picture of the QlikView development team. Credits for this discovery go to blog.heldendaten.net (an interesting blog, by the way).

Visual FX in QlikView (3)

With so many people commenting positively on my previous two pointless-but-pretty visual effects in QlikView, I’ve decided to make it an irregularly recurring Friday-afternoon series. At least, until I run out of ideas or opportunities to build these applications.

This time I’ve created an animated fire effect using a scatter plot. Like the previous two effects it has absolutely no practical application, unless you’re pitching QlikView to Industrial Light & Magic 😉 The video below demonstrates the effect.

 

If you want to try the application for yourself, you can download it by clicking the link below. Beware that the application is quite memory-hungry, you’ll need at least 4GB to run the app.

Download the QlikView Animated Fire app

Earlier posts in this series:

Show all sheets and sheet objects

Show all sheets and sheet objectsAs promised in the previous post, today I have a tip for you that is of real, practical use.

Management summary: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible.

Full story: Condtional show expressions are used in QlikView to show or hide a sheet or sheet object depending on if a predefined condition has been met. While this is extremely useful functionality to make your applications more user-friendly, it can be a real hassle during development.

If you want to edit a sheet or object when its show condition has not been met, you either have to make a selection that matches the condition, or you have to dig deep into the menu (Settings | Document Properties | Security | Show All Sheets and Objects) to disable, and when you’re done re-enable, conditional display. We all have better things to do with our time, for example reading blog posts that are way longer than they need to be.

Fortunately, in QlikView Desktop (‘classic’ view, not WebView) there is a shortcut: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible. Now you know.

Visual FX in QlikView (2)

After the many enthusiastic responses to last week’s post on visual effects in QlikView, I’ve decided to post one more pretty-but-pointless animated chart before returning to the serious stuff. This time I’ve created a plasma effect using an animated scatter plot in QlikView. The video below demonstrates the application.


If you want to try out the application yourself, you can download the full application below.

Download the QlikView Animated Plasma app

That’s it for this time. The next post will have practical use again, I promise 😉