Overview

This lesson handles the general organisation and structuring of QlikView projects. Based on our longtime experience with software development and QlikView implementations, we here show our “Best Practice”.

As easement for our own projects we provided an online template which enables the development of stable BI-solutions following our standards.

https://github.com/FrenzelGmbH/qlik

Screenshot 2015-03-28 15.02.53

Folder structure

  • ADMIN
    • COMMON
      • 00 CONFIG
      • LIBS
    • DEV
      • 01 Dataloader
      • 02 Datastaging
      • 03 Datalogic
      • 04 Datamart
    • PROD
      • << as DEV >>
  • ANALYSIS
    • COMMON
    • DEV
    • PROD
  • CONSOLE
    • MAINTANANCE
  • DEPLOYMENT
  • DOCS
  • VERSIONING

The goal of these structures is to create a distinct line between productive and development systems – without an additional testserver. Only if all logics work with test structures, a migration to a productive environment can happen.

Working with variables

To develop a “company solution” it is useful to work with global variables, which everyone can use. This is going to work like the following:

To award global variables, QlikView offers the possibility to include external TXT-files into the current script and to execute them “right here, right now” via “include”.

The difference between LET and SET variables is the evaluation of the expression behind the “equal” symbol. LET immediately “calculates” the expression while SET saves the expression for use later on.

If variables have been defined in “load_external_file.txt” then they are now available.

Models for script blocks

Here are some exemplary script blocks which are recommended to integrate into every QlikView script.

Please keep in mind that depending in which environment you are situated and also that “include” has to be controlled from external sources. The debugger helps with this by showing external sources in seperated riders.

QlikView Components

For the completion of periodic patterns, the QlikView veteran Rob Wunderlich wrote a library which eases exactly these patterns. In our projecttemplate we permanently update it and we recommend you to use it as well.

This is how you integrate the library:

To help with this topic, QVWs, a comprehensive documentation, have been provided. We now get to know a few of the useful routines:

Take one day to get an overview of the features. In our practical experiene you are going to save much time with doing this.

In the folder Libs/QVComponents/examples are examples for all functions if you are sill unconfident with using them.

Exercises

  • Download a “zip” from the project and build a “first” dataloader in the DEV index.
  • Use the include function to gain access to “global” elements

 

Leave a Reply