Qlik Sense WordPress Plugin v1.3.1

A new release of the Qlik Sense WordPress Plugin is out. Version 1.3.1 brings the following tweaks and changes:

• Fixed a bug where clicking cancel on the shortcode insert popups still inserts the shortcode
• Made the plugin clean up all its settings uninstalled
• Made the plugin translation ready and included en_US and en_GB translations

If you'd like to help translate the plugin into other languages, please get in touch.

If you have the plugin installed already, the update should become available in the WordPress admin control panel of your site. Full details of how to install and use can be found here.

Qlik for WordPress Plugin v2.0

Qlik for WordPress v2.0 has just been released. This release provides the biggest improvements to date, bringing a large number of new features as well as the usual tweaks and bug fixes.

If you've tried the plugin before and found it stopped other features and plugins from working, give it another try as hopefully this issue has now be resolved.

Plugin Settings Page

The plugin now has its own settings page where you can turn on or off the otional features.

Qlik for Visual Studio Code v0.4.0

After my recent post regarding text editors for working with QlikView and Qlik Sense script files, Visual Studio Code was top of the wish list. There was already a Qlik VS Code extension available in the VS Marketplace, that whilst not perfect was a great start. So I reached out to it's author Xavier Hanh with an offer to collaborate on improving the syntax highlighting it offers.

I'm pleased to announce the first fruits of the collaboration, a new release of the Qlik for Visual Studio Code extension.

Qlik Sense WordPress Plugin

Whilst updating the Qlik for WordPress plugin recently, I noticed that it was no longer the only Qlik related WordPress plugin available. The newcomer, produced by Yianni Ververis of Qlik, allows you to easily embed Qlik Sense charts, tables and other objects into posts and pages on a WordPress powered website.

You can find full details and instructions on how to install and use this plugin here or alternatively, below is a quick video from Qlik:

I've been working with Yianni over the last week to offer some improvements to make the plugin even more simple to use. The new release 1.3.0 is available to download now!

Qlik Notepad++ Language Definition v2.5

A new version of the Qlik Notepad++ Language Definition has been released. Version 2.5 contains the following functionality improvements and bug fixes:

• Added Qlik Sense connection string support
• Added the missing keywords DERIVE and FLUSHLOG
• Added support for DIRECT QUERY statements
• Corrected issue with some keywords not highlighting when touching a semi-colon
• Added support for QlikView Components variables and sub routines
• Other minor improvements

This release contains the following known issues:

• The if() function is highlighted in bold. This is because Notepad++ can't differentiate between the if() function and the IF statement. No known solution is available for this issue.

It is recommended that this release be used with Notepad++ version 6.6.9 and later.

As always, head over to the Notepad++ Language Definition page (or Branch) for the download link and instructions.

Qlik for WordPress Plugin v1.2

Qlik for WordPress Plugin version 1.2 has been released and included the following updates:

• Minor bug fixes
• Update to the Highlight.js core

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 WordPress.org website.

Qlik Web Syntax Highlighter v1.2

Qlik Web Syntax Highlighter version 1.2 has been released and included the following updates:

• Minor bug fixes
• Update to the Highlight.js core

As always, grab the download link and full instructions from the QlikView Web Syntax Highlighter page. If you find any issues or have any suggestions, please leave me a comment below.

A new version of the Qlik for WordPress Plugin based on the Web Syntax Highlighter is planned for release shortly.

QlikView Components v10.1 Released

A new version of QlikView Components (QVC) is now available. Version 10.1 brings bug fixes and improvements to additional functionality. This new release can be downloaded from: https://github.com/RobWunderlich/Qlikview-Components/releases/tag/v10.1

Changes for V10.1:

• Closed issue 23. Non-English characters not supported in log file. (Thanks to Alkopfer)
• Qvc.Log -- New variable Qvc.Log.v.WriteToQvLog, indicated if the logging should also be written to the QlikView/Sense application log file and script progress window.
• Closed issue 24. Qvc.IncrementalSetup failing when QVD exists but is empty. (Thanks for Luca Jonathan Panetta)
• Qvc.SegmentedStore -- New segment type of 'day' added to create daily QVDs.

You can read the full release notes here.
-Matt

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: https://github.com/RobWunderlich/Qlikview-Components/releases/tag/v10

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.

-Matt

QlikView Web Syntax Highlighter v1.0

Hot on the heals of last week's release of QlikView for WordPress, I'm pleased to announce the first full release of QlikView Web Syntax Highlighter v1.0 which the WordPress plugin is based on.

QlikView Web Syntax Highlighter provides basic syntax highlighting of QlikView script and expressions within web pages. It utilises a custom build of Highlight.js to apply the highlighting dynamically when the web page is viewed.

This version includes the following functionality:

• Highlighting of all current (v11.20) functions
• Highlighting of all current (v11.20) keywords and statements
• Highlighting of line comments (//) and block comments (/* */ and REM ; )
• Highlighting of variable definitions (SET and LET)
• Highlighting the usage of variable within dollar-sign expansion $( )
• Highlighting of field names in most situations 

As always, grab the download link and full instructions from the QlikView Web Syntax Highlighter page. If you find any issues or have any suggestions, please leave me a comment below.

QlikView for WordPress Plugin v0.2

As you may well have seen already, yesterday I released the first official pre-release of QlikView for WordPress plugin. This plugin brings syntax highlighting of QlikView script and expressions within posts and pages to WordPress blogs and websites.

The syntax highlighting is currently an approximation of that within the QlikView script and expression editors. It is however expected that the highlighting will be improved in later versions. The next version will include significant improvements to highlighting of expressions as well as some minor bug fixes.

Downloads and full instructions for installation and use can be found on the QlikView for WordPress page, or alternatively on the WordPress.org website.

Coming soon - QlikView Syntax Highlighting for the Web

I thought I'd let you all in on another little project I've been tinkering with on the side. I have had a long standing problem when blogging about QlikView. Most of my posts contain snippets of QlikView script or expression code which can be very hard to read if it is not syntax highlighted in at least an approximation of how it is highlighted within QlikView. I considered using images taken from screen grabs of the code in QlikView, but this means readers can't copy and paste the code into their QlikView projects making it less than ideal. And so I am left with the time consuming task of having to manually highlight code snippets in my posts, and this means less time for new posts.

//Define the table name
SET vMyTable = 'MyTable1';

//Load in the table of data
$(vMyTable)_Temp:
LOAD
    A,
    B,
    text(C) & ' a string' AS C
RESIDENT $(vMyTable);

Getting Started with Qlik Sense

Yer yer I know, its about time I put together my first post about Qlik Sense. Better late than never hey. As a starting point, I thought I'd post the below video "Qlik Sense Desktop - quick build tutorial" from Qlik. It is the best "get started guide" I've found so far. It walks you step-by-step through getting Qlik Sense installed to creating your first visualisations and answering business questions. And you don't need to be a coding whiz either, not a single line of script was hurt during the making of this video.