Tag Archives: excel

Importing and exporting variables

Importing and exporting variables in QlikViewWhen using variables in QlikView, a common best practice is to store them outside your QlikView application, or to define them in the script. However, there’s one thing about this approach that often annoys me. When defining a new variable during development, you either have to:

  • define the variable twice: once in the variable editor and then again in your external file/script to ensure that it is persisted;
  • or, define it once in your external file/script and then reload the application to make it available in the front-end, potentially leading to a lot of unnecessary downtime.

Fortunately, there is a solution that lets you define your variables once in an external file -and- have it available in the front-end (almost) immediately without reloading. read more »

Excel and VBA: the poor man’s QlikView

Today I have something completely different for you. It is only tangentially related to QlikView and lacks any practical application for QlikView professionals, but I know it will make you smile when you see it.

A few years ago I was the technical lead on a project that required the development of multiple Excel dashboards. I designed and developed (together with Nico Wuite, who did a lot of the coding) an Excel plug-in that could be used to generate stand-alone, fully interactive Excel dashboards. I recently rediscovered the plugin after cleaning up my archive of Excel and VBA reference files and thought it would be fun to generate a demo dashboard.

Have a look at the embedded video below (preferably in full screen HD) and see if it reminds you of a certain BI tool 😉 Also, keep in mind that this was built before PowerPivot was released, so it is a little dated by now.

QlikView blog round-up: Intellectual Curiosity & QVExcel

QVExcelAs I’ve been seeing many interesting QlikView articles and blog posts appear recently, I’ve decided to make the Blog Round-up a (bi-)weekly item on this blog. This week, there were two articles that caught my interest:

read more »