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
Common QlikView /en QlikView Workarounds /en Script /en Tips n Tricks /en

QlikView Generate Dynamic Variables

Sometimes it could be very usefull to generate variable dynamicaly, in QlikView you can do this easily with a trick inside the load statement of you application! Here is a short example (will give you some examples for a smart usage later): TRACE — LOAD ACTION AND EVENT —; VariableTable: LOAD DISTINCT tblActionType.ActionType AS VariableName […]

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

QlikView BestPractice – Keep your solution simple!

Introduction I develop QlikView solutions now since more than 4 years and I write software since more than 15 years 😉 damn I’m getting old… So as I started to work with QlikView I was more than fascinated by the “easyness” of getting results shown. But als live seems to be simple, the real world […]

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

Geolocating with QlikView and Yahoo Placefinder REST API

Why? Everyone who analysis company or private data has a regional aspect. Knowing your customer although means to know where he is located. As I found a lot of interesting HowTo’s on the internet, but sadly none that really fits my needs… I decided to write a complete HowTo for QlikView and Yahoo’s Placefinder API. […]