Category Archives: Macro

Extracting embedded images from QlikView

ImageExtractor for QlikView

ImageExtractor for QlikView

ImageExtractor is a small utility that extracts images from your QlikView applications and stores them as bitmaps. It also gives you a browser that tells you which images are used in which QlikView application.

read more »

QlikView macro’s are bad!

Last Thursday I did a presentation at the Qlik Dev Group NL about QlikView macro’s. While the title Macro’s are bad! suggests that I have a very firm view on macro’s, of course the actual presentation is much more nuanced. I wouldn’t be talking about macro’s if I didn’t think they have their uses 😉

In my presentation, I identify some potential use cases for macro’s and discuss if these are a good idea. Next, I share some tips on developing and debugging your macro’s. There are a lot of myths around macro’s, so I have taken a look at which ones are actually true. The presentation concludes with an overview of some of the cool macro’s that are already out there.

You can find my slide deck below:

The examples that I used in my presentation can be downloaded using the link below:

Download the macro examples

I hope you will enjoy these slides. If you have any questions or, also interesting, a different opinion, then feel free to post to the comments section below.

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 »