topic Re: "Qlikview Components" Open Source Project in QlikView

"Qlikview Components" Open Source Project

rwunderlich — Thu, 01 Dec 2011 18:45:55 GMT

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

"Qlikview Components" Open Source Project

johnw — Fri, 02 Dec 2011 17:52:34 GMT

Where would you like general feedback on the project? Such as, for example, some thoughts on issues with and enhancements to the calendar? I'm guessing the user forum of the project? There's also an issues section, but I'd think that would be for very specific things, kind of like a bug tracker?

"Qlikview Components" Open Source Project

rwunderlich — Fri, 02 Dec 2011 17:59:01 GMT

Please use the project User Forum for how-to questions, enhancement requests and general discussion.

Use the Issues section only to report defects.

Thanks for posing the question. I'll add this clarification to the project home page.

-Rob

"Qlikview Components" Open Source Project

rwunderlich — Tue, 13 Dec 2011 08:31:04 GMT

A new distribution 0.5, is avaiable in the downloads page at

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

Changes in this verson:

- Fixed Qvc.LinkTable to isolate effect of multiple calls with

different field lists.

- New Sub Qvc.CalendarFromField to generate calendar from existing

field.

- New Function Qvc.FieldContains. May be used in charts.

- Qvc.Calendar, force concatenation if subsequent call uses same

calendar tablename as existing table.

-Rob

http://qlikviewcomponents.org.

"Qlikview Components" Open Source Project

Tue, 03 Jan 2012 05:41:38 GMT

Hi Rob,

Great initiative. I could think of several additions to this project. I'm originally a technical SAP consultant (since 1987) and mainly working on SAP related QV implementations. There's several things I could think of having in your project specifically related to SAP, for instance currency conversion, which is pretty specific in SAP, but once scripted, used over and over again.

Regards,

Rob

"Qlikview Components" Open Source Project

rwunderlich — Tue, 03 Jan 2012 06:24:07 GMT

Hi Rob,

I would love to see your suggestions. Post your ideas on the User Forum at http://groups.google.com/group/qlikview-components-users .

-Rob

"Qlikview Components" Open Source Project

rwunderlich — Tue, 03 Jan 2012 06:25:00 GMT

New blog post about the project:

http://qlikviewnotes.blogspot.com/2012/01/introducing-qlikview-components.html

-Rob

"Qlikview Components" Open Source Project

rwunderlich — Fri, 06 Jan 2012 02:11:38 GMT

A new distribution 0.7, is avaiable from the downloads page at

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

Changes in this version:

Version 0.7

- Default for Qvc.Log.v.WriteLogFile is now '0' -- no external log.

- Corrected Calendar variables from "Qv.*" to "Qvc.".

- Modified Qvc.CalendarFromField to automatically link on field.

Version 0.6.2

- Qvc.Calendar. Fixed script error when string date parameters. (Issue #1).

Version 0.6.1

- Added missing etc directory to distribution. (Issue #2).

- New language files for Finnish, French, Norwegian and Swedish.

-Rob

http://qlikviewcomponents.org

"Qlikview Components" Open Source Project

rwunderlich — Fri, 06 Jan 2012 02:13:33 GMT

New blog post on doing Point In Time analysis using Qvc.CalendarFromField.

http://qlikviewnotes.blogspot.com/2012/01/easy-period-analysis-using-qlikview.html

-Rob

"Qlikview Components" Open Source Project

rwunderlich — Tue, 17 Jan 2012 22:02:03 GMT

A new distribution 0.8, is avaiable from the downloads page at

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

Changes in this version:

Version 0.8

- Qvc.Calendar. Added optional FirstMonth parameter to generate fiscal year calendar.

- Qvc.IncrementalSetup. Support for incremental load using revision column type.

- Added German (DE) language file.

- Unit testing now done with QV9, 10 & 11.

- Qvc.Log. Log line# preserved when keeping existing log records.

- Qvc.Calendar. Added _WeekSerial field.

-Rob

http://qlikviewcomponents.org

"Qlikview Components" Open Source Project

rwunderlich — Thu, 19 Jan 2012 16:47:46 GMT

A new blog post on doing Incremental Load with Qvc:

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

-Rob

"Qlikview Components" Open Source Project

rwunderlich — Thu, 02 Feb 2012 01:42:57 GMT

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

"Qlikview Components" Open Source Project

rwunderlich — Mon, 13 Feb 2012 15:35:04 GMT

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.

Re: "Qlikview Components" Open Source Project

rwunderlich — Fri, 09 Mar 2012 21:06:04 GMT

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

Re: "Qlikview Components" Open Source Project

rwunderlich — Wed, 11 Apr 2012 04:13:22 GMT

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

"Qlikview Components" Open Source Project

rwunderlich — Wed, 30 May 2012 17:05:56 GMT

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

Re: "Qlikview Components" Open Source Project

rwunderlich — Mon, 30 Jul 2012 23:00:38 GMT

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

Re: "Qlikview Components" Open Source Project

rwunderlich — Thu, 16 Aug 2012 16:55:08 GMT

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

Re: "Qlikview Components" Open Source Project

Tue, 13 Nov 2012 17:02:00 GMT

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

Re: "Qlikview Components" Open Source Project

rwunderlich — Tue, 13 Nov 2012 22:37:26 GMT

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

-Rob