Export a Chart or Tablebox via VBScript

As sometimes it makes sense to export data with a loop using VBScript. This little toolset should do the job for you:

Be aware that you need some helpers:

and finally you can export the object like this:

Take care that you’ve added the variables for the path in you enviroment variables […]

Read More →
Update QlikView Services by batch

 

Read More →
QlikView and Google Analytics – primary key issues

The main challenge I’m facing now, is the definition of a primary key, that allows me to build up my own data mirror to google analytics without messing up the metrics. Walking around on the internet, I found a lot of interesting articles about this and the best solution to come up with, seems to […]

Read More →
QlikView and Google Analytics – Getting Started

Hello, as I got the challenge to integrate Google Analytics into our company warehouse with QlikView I will write a series of hopefully more or less usefull articles on how to fetch the data needed. For accessing the Google Analytics API (v3) you have two possibilities: You are a technic geek and you know how […]

Read More →
Source Control for QlikView with git

What you need? So, facing the general question of “reasons” for lacking data quality, one of the most important thinks is transparency within the creation of the KPI’s. To reach this aim, I’ll switched to a full version control management with git to show my QlikView “customers” from where possible “issues” may resulting. To reach […]

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 →
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 →
Read and Write QlikView ObjectIDs by Macro

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

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 →