Kategorien
Allgemeines Qlik Script

Datamodelling Qlik Concatenate, Power BI Combine, SQL Union

The last 6 months have been quiet full of many new things to learn – after working more than 10 years with qlik and SQL a new player named “Power BI” has been added to my skills. So getting more and more used to it, I feel, like I should give other qlik developers to […]

Kategorien
Allgemeines Qlik Script Tips n Tricks

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

Kategorien
Allgemeines Qlik Script

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

Kategorien
Developer Schulung Qlik Script

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

Kategorien
Allgemeines Qlik QlikView Workarounds Script Tips n Tricks

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

Kategorien
Qlik Script Tips n Tricks

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

Kategorien
Qlik Script Tips n Tricks

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