Tips n Tricks QlikView Script
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...
* @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 <firstname.lastname@example.org>
SUB LoadSourceTableByName(TableName, Historical)
LET varTableName = TableName;
SQL SELECT * FROM spaceman.$(varTableName);
// Here we store the table as is into the filesystem
STORE $(varTableName) INTO "$(PATH_DATASTAGING)$(varTableName).qvd" (qvd);
IF Historical = 1 THEN
// ATTENTION, if you save historical data, pls. ensure that a folder with the tablename name exists within the datastaging root folder!
STORE $(varTableName) INTO "$(PATH_DATASTAGING)HISTORY/$(varTableName)/$(varTableName)$(VERSIONDATE).qvd" (qvd);
DROP TABLE $(varTableName);
Sorry, typo in the path variable, now fixed! Enjoy the script!
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...
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,...