"Qlikview Components" Open Source Project

[rwunderlich]

Today I launched an open source project named "Qlikview Components".  My goal is to simplify some of the common scripting tasks and develop a community supported standard for scripting.

Here's the mission statement:

Qlikview Components (QVC) is a library of script subroutines and functions. The mission of Qlikview Components is:

• Implement scripting best practices encapsulated by a simple and stable API.
• Improve the speed and quality of script development.
• Create common ground between script developers.

You can find the project at http://qlikviewcomponents.org. There you'll find links to downloads, forums and an issue tracker.

The example and documentation qvw files in the project are not Personal Edition enabled. PE users can use QVC, they just can't open the documentation yet.

Feedback welcome.

-Rob

http://robwunderlich.com

[rwunderlich]

A new blog post on doing Incremental Load with Qvc:

http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html

-Rob

[rwunderlich]

The first production release, 1.0 is now available from

http://code.google.com/p/qlikview-components/downloads/list

Issues and Discussion links are available on the project home page at:

http://qlikviewcomponents.org

-Rob

[rwunderlich]

A new version, 1.1 is available in the downloads at

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version:

Version 1.1

- Fixed issue 5. Qvc.LogWarning deleted variable.

- Incremental Reload -- added capability to force full reload.

    * Added ForceFullReload parm to Qvc.IncrementalSetup.

    * Added ReplaceQvd parm to Qvc.UpdateQvd.

- Fixed issue 8. Corrected variable names in language files.

- Added etc/QvcSheetObjects.qvw. Example sheet objects for use with Qvc.

- New Sub Qvc.JoinGenericTables rejoins separate tables created by Generic Load.

- New Sub Qvc.QvcUpdateAvailable tests if newer version available for download.

- IncrementalUpdate -- The "min=,max=" log message values will be formatted as timestamps only if using a Datetime modfield.

[rwunderlich]

A new version, 2.0 is available in the downloads at

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version:

Version 2

- Added config variable Qvc.Loader.v.KeyFieldIsUnique to support non-unique keys in Incremental Load and QVD updates. (Issue 10).

- Added table filtering parm to Qvc.TableStats. (Issue 11).

- Added Dutch (NL) language file.

-Rob

http://qlikviewcomponents.org

[rwunderlich]

A new version, 3.0, is available for download from

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version:

- New sub Qvc.ListDirectories.

- Fixed issue 14, script error in Qvc.UpdateQvd when space in keyfield name.

- Added Indonesian (ID) language file.

- Fixed issue 15, Qvc.GetFieldValues() returns numbers with max 9 digit precision on V9/V10.

- Fixed issue 16, some components, e.g. Qvc.GetFieldValues(), fail if "QUALIFY *" in effect.

- Added config variable Qvc.Loader.v.Database. Specifies the database product name. Possible values are SQLSERVER | ORACLE.

- Support for Incremental Reloads using Oracle.

-Rob

http://qlikviewcomponents.org

[rwunderlich]

A new version, 4.0, is available for download from

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version:

- New Code Extension facility for adding fields to the Calendar.

- Restyling of the Documentation.qvw.

- Qvc.IncrementalSetup, added new database value "Qvc.Loader.v.Database=SFDC" for loading from SalesForce (Issue 17).

- Qvc.TableStats, now using ThousandSep variable to format numbers (Issue 18).

- Removed Tab indicators from Qvc.qvs to allow Qvc to be inserted (instead of included) in a qvw.

-Rob

http://qlikviewcomponents.org

[rwunderlich]

A new version, 5.0, is available for download from

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version.

- Added new Sub, Qvc.DataLineage.

- Fixed Issue 22, sample CalendarExtFields.qvs should use WeekYear() instead of Year().

- Issue 23. Removed min/max reporting message from Qvc.IncrementalStore. Finding the values added significant runtime to large tables.

Qvc.DataLineage builds a table of the sources used in a qvw. Can be used to automatically include a data lineage chart in a qvw. It requires that the QVW be reloaded in QV10 SR2 or better.

Note there is an outstanding bug in QV11 where old lineage data is not being dropped from the QVW. So you may not have accurate results from a V11 QVW if you remove a data source -- until this bug is corrected.

-Rob

[rwunderlich]

A new version, 5.1, is available for download from

http://code.google.com/p/qlikview-components/downloads/list

Changes for this version:

Fixes issue 24. Qvc.CreateWildMatchExpression may produce incorrect results when repeated target value.

-Rob

[#10]

Hi Rob,

First of all, great job! Second, my question: if is possible to present the documentation in PDF for PE users?

Thanks for all,

Yago

[rwunderlich]

I've got that on my list of things to do. I'll post here when it's available.

-Rob