QlikView for Wordpress Plugin

The QlikView for Wordpress plugin gives basic syntax highlighting of QlikView script contained within Wordpress pages and posts. It is based on QlikView Syntax Highlighter for the Web.


The syntax highlighting that is provided is an approximation of what you would get in QlikView's Edit Script dialog. It currently supports the following features:
  • 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 $( )

If you find any issues, including missing keywords or functions, then please let me know using the "Contact Me" page and I'll add them to the next release.

This plugin is also featured on the Wordpress.org Plugin Directory to allow automatic installation and update notifications.

Installation

Here are the steps to get it installed and working yourself:
  1. Login to your WordPress Admin Portal.
  2. On the left hand navigation panel, select "Plugins". 
  3. Towards the top of the plugins list, click the "Add New" button. 

  4. In the search box towards the right hand side, type "QlikView" and hit enter to search.

  5. The QlikView for WordPress plugin is currently the only result returned. Click the "Install Now" button next to it.

  6. WordPress will then download and install the plugin for you. Once complete, click the "Activate Plugin" link to complete the installation.

  7. The plugin is now installed and the shortcode is ready to use.


Upgrading

Assuming you have used the above installation method, like other WordPress plugins, you will be notified when a new version of the QlikView for WordPress plugin is available. Follow the prompts within the notification to upgrade to the latest stable release.

How To Use

The plugin utilises a WordPress shortcode to apply the highlighting. Simply wrap any QlikView code blocks within the [qlikview] ... [/qlikview] shortcode tags. By default, the plugin will assume that the code contained in the tags is QlikView script and will highlight it accordingly. You can specify an alternative code type using the type parameter within the opening tag. For example:

[qlikview type="exp"]=num(MyField)[/qlikview]

Alternatively, the shortcode can be entered using the button within the Wordpress visual post/page editor. Select the block of code within the post or page, then click the QlikView button on the editor menu. You will be prompted for what language code block should be highlighted as. Once complete, click OK and the shortcode will be added around the code block for you.


It currently supports the following code types:
  • "qvs" - QlikView Script
  • "exp" or "qve" - QlikView Expression
  • "sql" - SQL
  • "vbscript" - Visual Basic Script
  • "javascript" - Java Script
Syntax highlighting will then be automatically applied to the block when the page is viewed.

Disclaimer

This plugin is provided free of charge, as is, with no warranties or guarantees. Neither Datoniq Limited or QlikViewAddict.com (including any of it's contributors) accept any liability for problems or loss resulting from it's use.

2 comments:

  1. Hi Matt,
    I noticed that the wordpress plugin is not handling variable declarations containing punctuation mark (.) correctly. Only the text before the first punctuation will render as grey.


    [qlikview type="qvs"]
    SET vL.ImportData = $(vG.ImportPath);
    SET vL.Measure.X = 'sum(Data_X)';
    [/qlikview]

    Cheers
    Vegar Lie Arntsen

    ReplyDelete
  2. Hi Vegar

    Good spot. I'll get it added in the next release!

    Regards
    Matt

    ReplyDelete