"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

[johnw]

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?

[rwunderlich]

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

[rwunderlich]

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.

[#5]

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

[rwunderlich]

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

[rwunderlich]

New blog post about the project:

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

-Rob

[rwunderlich]

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

[rwunderlich]

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

[rwunderlich]

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