Allgemeines QlikView Workarounds Tips n Tricks

Qlik XML aus Feld in Tabelle einlesen

Ausgangslage Der Kunde liefert eine Wertetabelle, bei der in einer der Spalten XML-Daten ohne feste Struktur vorhanden sind. Diese sollen so aufbereitet werden, dass diese Struktur als eigene Felder im Datenmodel aufscheinen. Tabelle: id Attribute Attributevalue FromDate 1 1 <Attr1>123</Attr1><name>Test</name> 42005 2 2 <price>10.50</price> 41911 Vorgehen Daten ergänzen <root> node Tabelle in XML Textdatei exportieren […]

Google Analytics Qlik QlikView Workarounds Tips n Tricks

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

Makros and Automatisation Qlik QlikView Workarounds Tips n Tricks

QlikView Export ChartTo XLS

This script enables you to export a ChartObject to xls by looping over a field, defined within a variable:  //Variables for the ExportObjectMakro Let pstrFieldName = “Standortname”; Let pstrExpObject = “CH526”; Let pstrExpPath   = “C:\ttemp”; REM ** MAKRO TO EXPORT OBJECT TO EXCEL ** rem Developed by Frenzel GmbH rem Author Philipp Frenzel Sub ExecByFieldValues […]

Allgemeines Makros and Automatisation Qlik QlikView Workarounds Tips n Tricks

Read and Write QlikView ObjectIDs by Macro

Here is a short script on how to read and write Object Id’s: SUB ReadObjectsAndSetId(SheetName)     rem ** minimize all sheet objects on sheet Main **     rem Author Philipp Frenzel     set s=ActiveDocument.Sheets(SheetName)     for i=0 to s.NoOfSheetObjects-1         ‘the formula for our rights management         varVisibility = s.GetProperties.SheetId & s.SheetObjects(i).getObjectId    […]

Allgemeines Qlik QlikView Workarounds Script Tips n Tricks

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): TRACE — LOAD ACTION AND EVENT —; VariableTable: LOAD DISTINCT tblActionType.ActionType AS VariableName […]