Draper & Dash - Qlikview Scripts

About

This website explains the functions and scripts that are common across many D&D applications. Including these functions and scripts in your development will help speed up the initial process and also make it easier for maintaining applications throughout their use. All these functions and scripts can be included by using the following line of code:

~~~~ $(include=https://raw.githubusercontent.com/GlutesDD/qlikview-scripts/master/DraperDashQlikviewScripts.inc); ~~~~

GenerateCalendar.qvs

CALL GenerateCalendar.qvs(Region, Date, Table)

Type:

Function

Parameters:

Region

The first parameter that must be supplied is the geographical region for the calendar. This can be UK, US or OZ for United Kingdom, USA and Australia respectively. The region will define how the financial calendar fields are being calculated.

Date

The second parameter is the data field you wish to use to associate the calendar to. This must be exactly the same as it appears in the data.

Table

The third and final parameter is the table that your date field is located in. This must match the table name exactly and must be available as a resident.

Description:

This script allows a calendar to be generated from a single function call and is included via the DraperDashQlikviewScripts.inc include file. You must create an inline table called Calendars with a single field Calendar. Type the name of the date fields used to generate each calendar as the field values.

GenerateCommonCalendar.qvs

CALL GenerateCommonCalendar.qvs(Region, PrimaryKey, Table)

Type:

Function

Parameters:

Region

The first parameter that must be supplied is the geographical region for the calendar. This can be UK, US or OZ for United Kingdom, USA and Australia respectively. The region will define how the financial calendar fields are being calculated.

PrimaryKey

The second parameter is the primary key field for your fact table, you must have a primary key in the table to be able to create a link between the common calendar and the fact table. This must be exactly the same as it appears in the data.

Table

The third and final parameter is the name of the fact table. This must match the table name exactly and must be available as a resident.

Description:

This script allows a common calendar to be generated which allows for analysing data in the same chart or object with a single data dimension where multiple calendars are needed. This is done from a single function call and is included via the DraperDashQlikviewScripts.inc include file. Please run this function after you have generated all other calendars.

IconsAndImages.qvs

Type:

Script

Description:

This script replaces the script in the D&D template called Icons and Images and loads into the qmem all the Icons and Images from the Resources folder. This script is ran on the inclusion of the DraperDashQlikviewScripts.inc include file and pulls in all Resources from http://discover.draperanddash.com/OpenData/Qlikview-Scripts/Resources.

ColourVariables.qvs

Type:

Script

Description:

This script replaces the script in the D&D template called Colour Variables and initialises the standard D&D colours used in the app template. This script is ran on the inclusion of the DraperDashQlikviewScripts.inc include file.

OutputTableAsHtml.qvs

CALL OutputTableAsHtml.qvs(Table, DestinationPath)

Type:

Function

Parameters:

Table

The first parameter is the name of the table you wish to be outputted as a HTML table. This must match the table name exactly and must be available as a resident.

DestinationPath

The second and final parameter is the filepath you wish to save the html file to, if this is left blank then the file will be stored in the same location as the qvw file.

Description:

This script generates a HTML file with the data table supplied formatted into a HTML table allowing the file to be pushed over the web and loaded into another Qlik application using the Web Files wizard. This is done from a single function call and is included via the DraperDashQlikviewScripts.inc include file.