Skip to content
Compare
Choose a tag to compare

New capabilities in v5.0.1:

  1. Ability to create QVDs from Web File connections with EXTRACT rules. Please see the last rule in the TABLES worksheet of SalesExtractRules.xls for an example.
  2. Support for new field creation with preceding LOAD in all 3 ETL stages. For examples, please see the TABLES worksheet in any of the following xls files: SalesExtractRules, SalesTransformRules and SalesLoadRules.

IMPORTANT NOTE: Generally, the preferred technique with which to create new fields are specific line item TRANSFORM_FIELDS rules, as shown on the TRANSFORM_FIELDS worksheet of SalesTransformRules.xls. This TRANSFORM_FIELDS technique provides much better traceability of new field derivation than does the preceding LOAD option. However, we now provide the additional option of new field creation with preceding LOAD in all 3 ETL stages, based on our users’ requests for the additional flexibility.

Compare
Choose a tag to compare

Added new optional multi-word mode for v4.1.3. For additional info, please see the related issue: #7

Compare
Choose a tag to compare

• Greatly enhanced the ETL Analysis app (which is under the ~\Admin folder).

• Simplified the ETL Analysis app script over 50% by re-using the same script routine for both EXTRACT and TRANSFORM statistics.
(Please see the revised ~\ETL Analysis Include.txt)

• Fixed synthetic keys in the ETL Analysis app by eliminating the old Historical Transform placeholder QVD.

Compare
Choose a tag to compare

Replaced hard-coded date field name with variable in the following file : CreateCalendarTable.txt (thanks to @AndrewGri!).
Please see the related issue #6.

Compare
Choose a tag to compare
  1. Fixed the following file (thanks to @AndrewGri!): Create New Qlik Sense App Folder from SEEQ Sales Sample.bat
    Please see the related issue #5
  2. Fixed misspelling in the Color_Variables.xls
  3. Added missing Folder and OLE-DB connections to Sales Dashboard.qvf
Compare
Choose a tag to compare

• Made 3-stage ETL the default in Qlik Sense QVFs; tagged as "deprecated" 4-stage files that require the (now unsupported) BINARY load
• Refined calendar creation; please see script tab 06 within each QVF and QVW
• Simplified the previously obfuscated definition of the QWT OLE-DB connection string in the Sales Extract QVF
• Fixed minor bugs in BAT files for creation of new folder structures

Compare
Choose a tag to compare

Added the Native Custom Report to the QVWs and QVFs within ~TSEEQ Sales Sample\4_App\

Added Sales Datamodel and Dashboard Combined.qvf under ~TSEEQ Sales Sample\4_App. This QVF is the combination of 2 separate QVFs from the 4-stage ETL architecture:
~\3_Load\Sales DataModel.qvf
~\4_App\Sales Dashboard.qvf
Combining these QVFs into this one avoids the need to BINARY LOAD the DataModel QVF. As such, this QVF implements the 3rd-stage of a 3-stage ETL Architecture. Please see the TSEEQ Documentation PDF for additional discussion of 3-stage and 4-stage ETL architectures.

Compare
Choose a tag to compare

• Documentation updates

• Added support for CSV rules source files (previously, only XLS format was supported for the rules files). CSV files are more version-control friendly since they are text and not binary.

• Added a new Utility, the TSEEQ Rule Converter. This utility converts XLS rules source files to CSV format. Editing XLS files is often preferred over editing CSV files, since XLS files can persist user-friendly attributes such as column width and highlighting. Development teams have requested the ability to edit their rules files in XLS format but manage & deploy in CSV format. The Rule Converter makes conversion of XLS rules into CSV rules a 1-click process.

Compare
Choose a tag to compare

Changes from v3.1.7b to v3.1.8:
• Added a new Qool Tool as a Qlik Sense QVF: the QVD ExtraQtor. The QVD ExtraQtor loads (BINARY) another app and creates a set of QVDs or CSV files (one per original table in the source app ). Please see the data load script in the QVD ExtraQtor QVF (under the Utilities folder) for additional instructions.
• The QVD ExtraQtor is still available in this release (as it was in prior releases) as a QlikView QVW.

Compare
Choose a tag to compare

Changes from v3.1.6 to v3.1.7b:
• Refactored multi-line C-style comments, to mitigate a bug where such comments prevented include file script execution.