QlikView Send Email by Passing Report ID as Parameter

Read More →
QlikView VBScript URL Encode

Read More →
QlikView Export ChartTo XLS

This script enables you to export a ChartObject to xls by looping over a field, defined within a variable:

Read More →
Color Blind of ChartObject

To save the trees, it can be very usefull to switch the chart from a colored version to a black white one. this can be done with the follwing macro and a button to execute…

Read More →
ColorTable QlikView HTML4 Color Loader

ColorManagement in QlikView is sometimes a bit of a pain. To get a subset of standard colors you can use this script and the appended csv-File to get the html4 standard colors (by name). This script enables you to import all standard html4 colors:

And you can download a zip example from here: Download […]

Read More →
Read and Write QlikView ObjectIDs by Macro

Here is a short script on how to read and write Object Id’s:

Read More →
WriteBack Logic

Write Back Logic This article is about how to store, retrieve and update informations related to a dataset. In my example I need to store datefields for a certain recordset and update them if needed.

Read More →
Building and Using a KPI Dictionary

Sample Scheme and Data for KPI Dictionary I build a small MYSQL Table to store the following fields: Label Definition Description Valid Inside the Definition I use a “special” syntax, so QlikView won’t crash while loading!

As you can see, I replaced the $-Sign with a §-Sign as the $ would be missinterpreted during […]

Read More →
QlikView Generate Dynamic Variables

Sometimes it could be very usefull to generate variable dynamicaly, in QlikView you can do this easily with a trick inside the load statement of you application! Here is a short example (will give you some examples for a smart usage later):

Read More →
QlikView Makro PDF Print with BullZip PDFCreator QlikViewPDF

Getting the Printer First of all you need to download and install the printer from the official BullZip Webpage, which can be found here: http://www.bullzip.com After the download and installation (GhostScript Requiered) you’ll find a new Printer in your System Settings. QlikView Parts Preparing your System Go to the macro modul in your QlikView Client. […]

Read More →