Tag 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.

Regular expressions in the load script

Regular expressions (or “regex”) are a developer’s best friend, they offer an extremely powerful way to search for or replace patterns in strings of text.

This post assumes that you already know how what regular expressions are and how to construct them. If this is not the case, then you may want to read up a little bit here before proceeding. Trust me, if you regularly have to deal with validating and cleaning input data then regular expressions are well worth your time.

Data validation and transformation using regular expressions, download the example application

Unfortunately, QlikView does not (yet*) natively support regex, however, there is a way to use regular expressions in your QlikView load script: VBScript. read more »