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
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
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
Common Macros and Automatisation QlikView /en Tips n Tricks /en

Export a Chart or Tablebox via VBScript

As sometimes it makes sense to export data with a loop using VBScript. This little toolset should do the job for you: Sub ExecByFieldValues SET Doc = ActiveDocument SET Field = Doc.Fields(getVariable(“pstrFieldName”)) SET Values = Field.GetPossibleValues FOR i = 0 TO Values.Count-1 ExportObject Values.item(i).Text NEXT End Sub Be aware that you need some helpers: rem […]

Categories
QlikView /en QlikView Workarounds /en Tips n Tricks /en

QlikView and Google Analytics – primary key issues

The main challenge I’m facing now, is the definition of a primary key, that allows me to build up my own data mirror to google analytics without messing up the metrics. Walking around on the internet, I found a lot of interesting articles about this and the best solution to come up with, seems to […]

Categories
QlikView /en Tips n Tricks /en

QlikView and Google Analytics – Getting Started

Hello, as I got the challenge to integrate Google Analytics into our company warehouse with QlikView I will write a series of hopefully more or less usefull articles on how to fetch the data needed. For accessing the Google Analytics API (v3) you have two possibilities: You are a technic geek and you know how […]

Categories
Macros and Automatisation QlikView /en Tips n Tricks /en

Source Control for QlikView with git

What you need? So, facing the general question of “reasons” for lacking data quality, one of the most important thinks is transparency within the creation of the KPI’s. To reach this aim, I’ll switched to a full version control management with git to show my QlikView “customers” from where possible “issues” may resulting. To reach […]

Categories
Macros and Automatisation QlikView /en Tips n Tricks /en

QlikView User Access and Object Access

Introduction Security is one of the main topics and issues, deploying data to different users or group of users. Additional you have to seperate between data filters and object/feature visibilities. To achieve a individual “restriction” we split access rules into: ObjectRights (What a user can “see”) AccessRights (Which data a user can “browse”) Scripts Here […]