Categories
Developer Teaching QlikView /en

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 […]

Categories
Developer Teaching QlikView /en

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 […]

Categories
Developer Teaching QlikView /en

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 […]

Categories
Common Macros and Automatisation QlikView /en Tips n Tricks /en

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: Sub ExecByFieldValues SET Doc = ActiveDocument SET Field = Doc.Fields(getVariable(“pstrFieldName”)) SET Values = Field.GetPossibleValues FOR i = 0 TO Values.Count-1 ExportObject Values.item(i).Text NEXT End Sub Be aware that you need some helpers: rem […]

Categories
Common

Connect QlikView to UpdateCRM – xmlInterface

Grepping metadata To get the information about a table, just use: <?xml version=”1.0″?> <request> <metainfo tablename=”Company”/> </request> Loading Data To retrieve all data from table company: <?xml version=”1.0″?> <request> <query dateformatout=”%Y%m%d” dateformatin=”ymd”> <tables> <table tablename=”Company”/> </tables> <fields tablename=”Company” fields=”*”/> </query> </request>    

Categories
Common QlikView /en

Update QlikView Services by batch

@echo off ECHO %date% %time%: started QV_restart.bat >>”QV_restart.log” REM ——————————————————- REM – File: QlikViewServer11_Stop.bat REM – Description: Stop all QlikView related services (v10) REM ——————————————————- echo Stop QlikView Services echo ====================================================== net stop “QlikView Server” net stop “Qlikview Directory Service Connector” net stop “QlikView Distribution Service” net stop “QlikView Management Service” net stop “QlikView WebServer” […]

Categories
Common

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. […]

Categories
Common

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 […]

Categories
QlikView /en QlikView Workarounds /en Tips n Tricks /en

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 […]

Categories
QlikView /en Tips n Tricks /en

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 […]