Friday 27 February 2015

Populate QlikView variables from an external file

When building multiple tiered QlikView solutions, it is often handy to be able to define global variables that are then used across all QVWs within the solution. For example, having a single variable that defines where QVDs are to be stored and loaded from, can make moving the app from a development environment to a production server a little quicker and simpler.

I'm starting to feel like a broken record saying this, but there are of course multiple ways to achieve this in QlikView. One method, and probably the most commonly used, would be to define the variables in a QlikView script file as follows:

SET vQVDPath = C:\QlikView\Data\QVDs\;

The script file can then be included in multiple QVWs by added the following line towards the start of each script:


Monday 23 February 2015

QlikView Components v10 Released

A new version of QlikView Components (QVC) is now available. Version 10 brings many new features and big fixes, most notably, the first additions from the merger of QVC with QlikView Addict CodeBox (QVACB). This new release can be downloaded from:

Changes for V10:
- QVC Documentation and Examples are Personal Edition enabled.
- Merged QVACB library with QVC.
    - Migrated Sub from QVACB, Qvc.Icons. Bundle loads image files into a QVW.
    - Migrated sub from QVACB, Qvc.QvdEmpty. Empties data from a QVD.
    - Migrated sub from QVACB, Qvc.SegmentedStore. STOREs table into segmented QVDs by date range.
    - Migrated function from QVACB, Qvc.DateDiff.
    - Migrated function from QVACB, Qvc.Days360.
    - Migrated function from QVACB, Qvc.NVL.
    - Migrated function from QVACB, Qvc.InRange.
- Closed Issue 12. Qvc.ExpandInterval script error when field name contains comma.
- Closed Issue 5. Qvc.DbExtract Initial extraction proceeds even when KeyField has typo in it.
- Closed Issue 4. Qvc. DbExtract Provide table specific BaseValue.

You can read the full release notes here.


Friday 13 February 2015

QlikView Addict CodeBox merging with QlikView Components

The QlikView Addict CodeBox (QVACB) isn't a thing most people will be familiar with; the reason why will become clear as you read on. Several years ago now, I had some time on my hands and so I set about collating into a single package, all the reusable and useful bits of QlikView code I had lying around. The end result was QVACB. My intention was that at some point I would release it so that other QlikView developers could make use it, but maintaining my other released tools (such as the syntax highlighting) kept getting in the way. And so QVACB has been sat on the virtual shelf, only ever getting as far as being released to a handful of QlikView consultants/developers in something loosely resembling an alpha trial. I'm sad to say it hasn't even been updated in well over a year.

Recently I started to receive a few messages from people asking me to fix issues or add features to QVACB. After a little digging, it transpired that QVACB was being used by more people than I had thought and in some cases even in production solutions. This made me consider what the best way would be to go about releasing it properly. However, the last thing I wanted to do was release something which I never got the time to maintain properly.

Thursday 12 February 2015

QlikView for WordPress Plugin v1.1

QlikView for WordPress Plugin version 1.1 has been released and included the following updates:
  • The highlight.js core has been updated to the latest release of highlight.js.
  • Improvements to the identification of field names in both script and expressions.
  • Added missing IN keyword.
  • Added missing filelist() function.
  • Other minor highlighting improvements.
If you installed the plugin from the WordPress Plugins Directory then you will be prompted to install the update next time you log in to your site's WordPress Admin portal. Alternatively, downloads and full instructions for installation and use can be found on the QlikView for WordPress page, or alternatively on the website.

Tuesday 10 February 2015

QlikView UltraEdit Wordfile v2.1

A new version of the QlikView UltraEdit Wordfile has been released to correct some minor issues. Version 2.1 contains the same fixes as the Notepad++ version as follows:
  • Added the missing keyword "IN"
  • Added the missing function "filelist()"
  • Other minor code improvements.
As always, full instructions and download links can be found on the QlikView for UltraEdit page or on Branch. A new version of my QlikView Web Highlighter to follow soon including an update to the QlikView for WordPress plugin.

QlikView Notepad++ Language Definition v2.4

A new version of the QlikView Notepad++ Language Definition has been released to correct some minor issues. Version 2.4 contains the following minor fixes/functionality:
  • Added the missing keyword "IN"
  • Added the missing function "filelist()"
  • Other minor code improvements.
As always, head over to the Notepad++ Language Definition page (or Branch) for the download link and instructions. New versions of my other syntax highlighters to follow shortly.