RightQlik: quick access to common operations on QlikView files

March 24, 2014 at 10:00 am 14 comments

If you’re a QlikView developer, you probably know that there are a few tasks that can be performed with QlikView from the command line. One of my favorites is the Open without data option (see below to read how it can sometimes be a real life saver). As this (and some others) is a really useful option, I think it should be more readily available to be used when needed without having to launch a cmd window or even create a .bat file. So, I created a custom context menu for QlikView files that puts these options just one click away (literally). Here is the result:

RightQlik

I will first introduce these options and why they can be useful. At the end of this post, you’ll find instructions to add this context menu to your own system.

 Opening a QlikView document without data

Besides the command line, there’s another way to open a document without its data: simply right click on the file from the list of Recently Opened Documents and select the corresponding option.

RightQlik_2

If you’re a developer, you’d normally use this option when reviewing script, expressions, or general layout of a QlikView document and don’t need to see the data contained in it. This is particularly useful if we’re talking about files that, when opened normally, would eat up a considerable amount of RAM in your computer.

The Open Without Data option is sometimes a life saver as well; and I can talk from experience. Once, I was about to present a demo we’ve made for a prospective customer and, just before the meeting started, I powered up my laptop and tried to open the file only to see the following message appear:

RightQlik_3

At some point during the last changes applied to the document, the file had became corrupt, we had no backups and everybody was there waiting to see the demo. Maybe just in a moment of luck, right before panicking, I right clicked and opened the document without data. My heart was beating again. After that, just a quick reload and we were off demoing QlikView again.

The command line, one qlik away.

But is this option only available from the Recently Opened Documents? What happens if you want to open without data a document that has not been opened before on your machine? As mentioned previously, there’s another option: the command line.

By using the command line, we can run QlikView and perform some common tasks, among which is the “Open Without Data” option. Just call qv.exe from the cmd window, specify a file to be opened, and add the /NoData switch. Other options include the ability to open and reload a qvw file, open a document overriding module security, etc.

All these options exist. However, in my opinion, these options should be more readily available, so that they can be easily used when needed. Enter RightQlik.

RightQlik

RightQlik is a simple custom context menu that’s shown when right clicking on a QVW file. This allows quick access to some common functions that a developer would often perform on a QlikView file:

  • Open in a new QV instance: This option will open the selected file in a new QlikView instance. This allows for quick switching between several QlikView files, opened in several windows.
  • Open without data: opens the document without also loading its data.
  • Reload document: Runs a reload of the QlikView script and closes the document. With this option, you can run simultaneous reloads of several QlikView documents with a simple click by first selecting all of them.
  • Reload and keep open: Runs a reload of the QlikView script and the document remains open after finished.

This custom context menu is only shown when dealing with QVW files, and will stay out of your way when dealing with any other file type.

To install, simply run the following exe file with administrative privileges and that’s it! The installation file is prepared to work on both 32-bit and 64-bit systems, and has been tested in several versions of Windows.

>> Download RightQlik <<

Ideas for new features?

I know there can be other potential uses for a custom context menu like this, and would very much like to hear your thoughts. If you have any idea in mind for other use cases, please share in the comment area below.

Disclaimer: I hope you don’t mind that, with the launch of our new website in sight, I’ve added a nonintrusive link to http://q-on.bi at the end of the context menu. This will help you get quick access to various resources (like this one) that we’ll be releasing.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.

QlikOn!

About these ads

Entry filed under: Development, Tools. Tags: .

QlikView 11 para Desarrolladores, ahora en español Keep Calm and QlikOn! – Announcing the launch of our QlikView Online Training Center

14 Comments Add your own

  • 1. Nate Brunner (@mcnater)  |  March 24, 2014 at 10:17 am

    Thanks for this…a very nice tool to have at my disposal.

    Reply
    • 2. Mike  |  March 24, 2014 at 2:26 pm

      Thanks Nate! I’m glad you found it useful.

      Reply
  • 3. Karl Pover  |  March 25, 2014 at 1:16 am

    Excellent Mike

    Reply
  • 4. Roland  |  March 26, 2014 at 10:05 am

    I love it! “Open in a new QV Instance” will save me quite some Clicks over the years :)

    Just gave it a post on our german speaking blog http://blog.heldendaten.net/

    Thx,
    Roland

    Reply
    • 5. Mike  |  March 26, 2014 at 10:21 am

      Thanks Roland, I’m glad you found it useful.

      Thanks for posting it on your blog as well :)

      Reply
  • 6. Steve Dark  |  March 28, 2014 at 2:48 am

    This is a really neat little widget. I always open apps in a new instance by starting from the task bar and then dragging the file into the Start window of QV. That menu option alone will save me many clicks.

    Reply
    • 7. Mike  |  March 28, 2014 at 9:55 am

      Thanks Steve!

      Reply
  • 8. Diego  |  March 28, 2014 at 4:24 am

    Nice one! thx
    Diego

    Reply
  • 9. Rob  |  March 28, 2014 at 2:07 pm

    Great tool. Thank you for sharing.

    Reply
  • 10. Abhijit  |  March 30, 2014 at 1:18 am

    I Just love ‘Open in a new QV instance’..
    It saves lot of clicks .
    many thanks for sharing.

    Reply
  • 11. Sander  |  March 30, 2014 at 3:45 pm

    The installation isn’t working when QlikView isn’t installed in the default folder. For example : C:\Program Files\QlikViewDesktop

    https://dl.dropboxusercontent.com/u/13188745/RightQlik.PNG

    Reply
    • 12. Mike  |  March 30, 2014 at 3:48 pm

      Hi Sander,

      Correct, when qv.exe is not installed in the default locations, you will be asked to enter the path manually into the cmd window (as shown in your screenshot). Please type the full path (for example: D:\Program Files\QlikView\qv.exe).

      If you have any further questions, please get in touch.
      Mike

      Reply
    • 13. Mike  |  March 30, 2014 at 3:50 pm

      Oh I see what’s wrong. You only typed the folder. Please enter the full path, including “qv.exe”.

      Mike

      Reply
      • 14. Sander  |  March 31, 2014 at 2:45 pm

        Wright! It’s working now, thanx!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,317 other followers

QlikOn!

Join us for one of our upcoming live QlikView courses!

Recent Posts

Twitter

Error: Twitter did not respond. Please wait a few minutes and refresh this page.


Follow

Get every new post delivered to your Inbox.

Join 1,317 other followers

%d bloggers like this: