Excel macro loop by sheet

Collect data from multiple excel tabs and put them together at a new collector sheet:

Read More →
Power BI Calender DAX

Generating a calender was a very important task within qlik sense/view – so even as the date functions within power query or dax are awesome, I still prefer to have an “inbuild” calender. To achieve this goal, you can switch to the “Modeling” view -> add a “Table” and then just copy and paste the […]

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

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 →