Lesson 4 – Structuring scripts and using functions

Overview To not lose track in longer scripts, you have the possibility to structure the script. QlikView offers you to classify via index cards. Additionally we use easy functions to enrich our datamodel. Generate an index sheet To simplify the finding of ladelogics in the script, structure the script by creating new tabs or moving […]

Read More →
Lesson 3 – load and document data

Overview In this lesson we are going to learn the most important rules of importing data. This is just a recommendation, not a “must”! Documentation – comments Th emost efficient form of providing your logics and thoughts to your fellows is to wirte comments within your scripts. You can write these at any point in […]

Read More →
Lesson 2 – Basic script syntax

Overview In this lesson we are focusing on the most frequent script commands and their practical application. Basic structure syntax Some of the most frequently used commands are: CONNECT SELECT LOAD With which data in QlikView can be identified and loaded If you are uncertain exactly how a command is used, use the in QlikView […]

Read More →
Lesson 1 – Data sources and data structures

Overview This lesson deals with the import of data sources and the general understanding of data structures. Data sources In today’s world, there are a variety of possible sources of data to be loaded and merged. The most common formats are: SQL Databanks (MSSQL, MYSQL, Postgres SQL, …) NOSQL Datenbanks (CouchDB, ElasticSearch, NoSQL, …) REST […]

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 – 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 →