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. Ihre Vorteile im Überblick: skalierbare Pläne für jegliches Ausgabegerät (Browser, PDF, Print) Ausgefeilte Logiken zur Ermittlung des schnellsten Weges Einfache Wartung mittels Standardsoftware (Bsp. Illustrator, Inkjet) Schnelles Laden, da reine “Textinformation”

Continue Reading

HR – Abwesenheitsverwaltung

Urlaubs- und Krankenstandsverwaltung Verwalten auch Sie in Zukunft mir unserer Lösung die Mitarbeiterabwesenheiten für Ihr Unternehmen. Im letzten Release 1.1 unterstützen wir die folgenden Basisfunktionalitäten: Arbeitszeitplanverwaltung Berechnung von Urlaubsneuansprüchen Urlaubsaliquotierungen Urlaubsrückstellungen Anwesenheitsverwaltung Sonderabwesenheiten Hochzeit Krankenstand Todesfall Umzug Urlaubsantrag Genehmigungsprozess Antragsteller Prüfung und Freigabe Korrektur Buchung Mitarbeiter Dashboard Hinweissystem Zeitüberschreitungen Krankenstandsmeldung Vertretungsprobleme  

Continue Reading


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 and easy to set up so that it works accurately and reliably in a wide range of environments.Eye tracking can be used in a wide variety of applications typically categorized as active or passive. Active applications involve device control, for example aiming in games, eye activated login or hands-free typing. Passive applications include performance analysis… Read More

Continue Reading

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 add it to your default calendar. Definition:

Continue Reading

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 you can see the real magic here is done in the FOR-TO-Loop, here it shows a cumulated budget figure, but you can easily change to a mothly figure!


Continue Reading

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 load 1 metric per request) First of all we need to define our googleAppIds within a static table.

Now we have to loop through our table:

  As our loadGoogleId Sub is still missing we have to add this here:

Here is just a loop to address every single month within our… Read More

Continue Reading
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 and the url with the (1hour) token included to load the data like this. Then I recommend that you put this token into a variable to which will be passed to the script while you wanna load it. Enhancement If you have multiple sites you wanna load, just pack the hole load script into a… Read More

Continue Reading

Project Documentation with github and markdown

A very important step while implementing more or less complex solutions is the availability of a documentation. While I’m really a fan of version based work, I will describe a quick an simple way, how I document my projects with github and markdown. For all of you who don’t know markdown, it’s a simple “what you mean is what you get” syntax which can be compared to LATEX. (If you don’t know this eather, pls. give a search engine a visit) 😉 So what you acutally need is: GitHub Account TextEditor (min.) if you are the more “what you see is what you get” person, you’ll find a lot of… Read More

Continue Reading

Prepare a new qlik project

Intro If you prepare yourself for a “seeing is believing” workshop or going to start a new qlik project. Be aware that you should prepare your work environment!  System Requirements Based upon the size of your data and the number of clients you need to “size” your server or developer workstation. For a minimum developer workstation you should at least have:  500GB HardDrive (2 Partitions 100,400) >= i5 (min 2CPU) 8 GB RAM For a minimum server you should at least have: 500GB HardDrive (2 Partitions 100,400) >= 4 CPU (current tech) 16 GB RAM If you wonder why the server needs “more” ressources, it’s because each user will generate… Read More

Continue Reading