Kategorien
Allgemeines Jedox

Jedox – User CRUD – Manage Dimensions within worksheet

Usecase Sometimes it´s needed that a user can add elements to a dimension without accessing the modeller – e.g. you wanna budget personal ressources and want to allow power users to add new placeholders to the employee dimension. To get this working, you can use multiple ways on how to pass values from the worksheet, […]

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

Kategorien
Allgemeines

Qlik Sense Configuration Management with Strapi.io

Overview Building more and more apps within qliksense I run into several personal optimisations that I wan’t to share with you. After a couple of pains I figured out how to workaround those issues and setup an enterprise ready architecture. Prequesits Install MongoDB pls. follow the guide on https://www.mongodb.com/download-center#community or just use a docker image https://hub.docker.com/_/mongo/ (I […]

Kategorien
Allgemeines Makros and Automatisation Qlik Tips n Tricks

QlikView Dynamic TableBox Creation

Reason Sometimes it makes sense to pass some SQL Views through the whole ETL-Process to e.g. use the View “AS-IS” within a NPrinting Report. To achieve this behaviour, wenn need 2 dynamic steps:

Kategorien
Allgemeines

Interaktive Gebäudepläne

  SVG-Gebäudepläne und Karten Sie haben Gebäude, die öffentlich oder für Ihre Kunden zugänglich sind. Sie möchten diesen eine Orientierung an die Hand geben? Mit unseren interaktiven Plänen und Karten haben wir eine Lösung für Sie. Mittels einfacher Algrorithmen lassen sich der kürzeste Weg oder auf Wunsch ein geplanter Weg durch z.B. Ihre Displays darstellen. […]

Kategorien
Allgemeines Services

Eye-Tracking

What Is Eye-Tracking Eye tracking is the process of using sensors to locate features of the eyes and estimate where someone is looking (point of gaze). Our technology relies on infrared illumination and uses advanced mathematical models to determine the point of gaze. We’ve spent a tremendous amount of effort on making it fully automatic […]

Kategorien
Allgemeines Qlik

Global Calendar

Having a well structured calender within your qlikview app allows you to build faster charts and reports. Speak to your internal customers about their report layouts and you’ll see that most people have a common sense on how to combine data over time. Below you will find a list of fields which we recommend to […]

Kategorien
Allgemeines Qlik Script Tips n Tricks

QlikView Generating Year over Year Targets

From time to time you have to create budget figures upon a percentage change compared to the last year. This can be a little bit difficult, depending on the complexity of the KPI. The following example is build upon a pre-cleaned datamart and shows how you create the monthly figures for you budget. /** * […]

Kategorien
Allgemeines Qlik Script

Load multiple GoogleAnalytics-Properties at once w/ dynamic metrics in QlikView

Our objective is to load GoogleAnalytics data, seperated in months with a dynamic metric, fixed dimensions and for multiple Properties. To achieve this we’re using the QlikView addon: QVSource. The script contains the following (important) variables: gAppId = googleAnalytics PropertyId vMetric  = the dynamic metric, we want to load (note that this script will only […]

Kategorien
Allgemeines Google Analytics Qlik

Loading Google Analytics with QlikView

General To keep reports compatible, the following dimensions are alway loaded as a minimum: ga:browser ga:deviceCategory ga:pagePath ga:date Add Measures Now as the dimensions are set, you can add up to 5 measures to be grouped by and displayed. QlikView Load Script Trace loading the values day by day; FOR zz = 2012 TO 2015 […]