Categories
Common QlikView /en

Global Calendar

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

Categories
QlikView /en Tips n Tricks /en

extended dataloader

/** * LoadSourceTableByName * @param TableName String the name of the table that will be exported * @param Historical Boolean if a historical version will be saved on a monthtly basis, pls. check comment! * @version 1.01 * @author Philipp Frenzel <philipp@frenzel.net> */ SUB LoadSourceTableByName(NameSpace, TableAlias, TableName, Historical) LET varTableName = TableName; LET varTableAlias = […]

Categories
Common QlikView /en Script /en Tips n Tricks /en

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. /** * […]

Categories
Common QlikView /en Script /en

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

Categories
Common QlikView /en

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

Categories
Developer Teaching QlikView /en Script /en

QlikView Script Sub for Dataloading

/** * LoadSourceTableByName * @param TableName String the name of the table that will be exported * @param Historical Boolean if a historical version will be saved on a monthtly basis, pls. check comment! * @version 1.0 * @author Philipp Frenzel <philipp@frenzel.net> */ SUB LoadSourceTableByName(TableName, Historical) LET varTableName = TableName; QUALIFY “*”; $(varTableName): LOAD *; […]

Categories
Common Developer Teaching QlikView /en

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

Categories
Common QlikView /en

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

Categories
QlikView /en QlikView GUI /en Tips n Tricks /en

QlikView – Color Blend by Dimension Value

Overview Sometimes you wanna define a “color schema” by the values of a dimension. The easiest way is to generate a mapping table where each dimensionvalue gets an color assigned. Downloads First load the color table as CSV from here and save them into the same folder where you wanna create and run the QlikView […]

Categories
Developer Teaching QlikView /en

Lesson 11 – complex data presentation

Overview In this lesson we get to know more complex data diagrams, which are properly suited for “intergroup” analysis. Trellis Trellis graphs serve the same visualization with a uniform scale to visualize different categories. You can decide yourself which dimensions you want to “distinguish”. In the advanced settings you can define the quantity per column […]