QlikView ObjectTypes

The following object types for macro automatisation are existing:

To read the object type you can use the following syntax:

You need this to manipulate the “Settings” which can be found “separatly” based upon the object type!

Read More →
QlikView User Access and Object Access

Introduction Security is one of the main topics and issues, deploying data to different users or group of users. Additional you have to seperate between data filters and object/feature visibilities. To achieve a individual “restriction” we split access rules into: ObjectRights (What a user can “see”) AccessRights (Which data a user can “browse”)  Scripts Here […]

Read More →
Quality Enhancements on User-Feedback

Dear all! Based upon recent user requests “readers” which are telling me, that content is always usable, but the presentation needs to be improved a lot… I promise for now and the future to keep in mind, that not every reader is already used to VBA or any other programming language. If an post seems […]

Read More →
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 →