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: idAttributeAttributevalueFromDate11<Attr1>123</Attr1><name>Test</name>4200522<price>10.50</price>41911 Vorgehen Daten ergänzen <root> nodeTabelle in XML Textdatei exportieren .xml (txt)Tabelle als XML wieder einlesen (Assistent)

Read More →
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 […]

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

Read More →
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 […]

Read More →
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 […]

Read More →
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.

As […]

Read More →
qlik view first quick chart
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

If you don’t have QVSource running, you can use the query explorer […]

Read More →