Lektion 2 – Grundlegende Skriptsyntax

Übersicht In dieser Lektion beschäftigen wir uns mit den häufigsten Skriptbefehlen, sowie deren praktischer Anwendung. Grundstruktur Syntax Zu den am häufigsten verwendeten Befehlen gehören: CONNECT SELECT LOAD Mit denen Daten in QlikView identifiziert und geladen werden. Sind Sie sich nicht mehr sicher, wie genau ein Befehl verwendet wird, nutzen Sie die in QlikView integrierte Hilfe. […]

Read More →
Lektion 1 – Datenquellen und Datenstrukturen

Übersicht Diese Lektion beschäftigt sich mit dem Import von Datenquellen und dem allgemeinen Verständnis von Datenstrukturen. Datenquellen In der heutigen Zeit gibt es eine Vielzahl von möglichen Datenquellen, die geladen und zusammengeführt werden sollen. Die gängigsten Formate hierbei sind: SQL Datenbanken (MSSQL, MYSQL, Postgres SQL, …) NOSQL Datenbanken (CouchDB, ElasticSearch, NoSQL, …) REST – SOAP […]

Read More →
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 →
Connect QlikView to UpdateCRM – xmlInterface

Grepping metadata To get the information about a table, just use:

Loading Data To retrieve all data from table company:

   

Read More →
Update QlikView Services by batch

 

Read More →
yii2 fullcalendar extension

Hi, due to some people are really using the yii2 fullcalendar extension – of course I use it in my own projects – I made some fixes, upgraded to the latest version 2.1 and put up an demo site of the extension, which can be found here: http://yii2fullcalendar.beeye.org/ Enjoy! If you have any questions, pls. […]

Read More →
Setting up a new workstation (apple mac pro)

Today I got a new MacPro, as my old one died of ram and batteries decease:( For myself and all other crazy developers, I describe what I’m setting up, step by step, to get a production machine! Startpoint To make it simpe, I just clicked through the apple wizzards and ended up with a ready […]

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 →
New Karaoke Catalogue

Hey, I just developed a karaoke catalogue. It show’s you how to use the amazing possibilities of big data and open data on how to put different content sources together and get a more or less powerfull application. I will enhance the app a little bit more within the next days! If you have any […]

Read More →