RightQlik: quick access to common operations on QlikView files

Inicio/RightQlik: quick access to common operations on QlikView files

RightQlik: quick access to common operations on QlikView files

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.

Donload RightQlik Now!

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!

By | 2017-05-23T10:56:34+00:00 March 24th, 2014|Development, Tools|20 Comments

About the Author:

Consultor Experto QlikView. Autor del libro “QlikView 11 for Developers” y su versión en español “QlikView 11 para Desarrolladores”, publicados en noviembre de 2012 y diciembre de 2013, respectivamente. También he colaborado con la editorial, PacktPublishing, como revisor técnico en otros libros sobre QlikView. Descarga mi presentación de servicios.

20 Comments

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

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

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

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

  2. Karl Pover March 25, 2014 at 1:16 am - Reply

    Excellent Mike

  3. Roland March 26, 2014 at 10:05 am - Reply

    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

    • Mike March 26, 2014 at 10:21 am - Reply

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

      Thanks for posting it on your blog as well 🙂

  4. Steve Dark March 28, 2014 at 2:48 am - Reply

    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.

  5. Diego March 28, 2014 at 4:24 am - Reply

    Nice one! thx
    Diego

  6. Rob March 28, 2014 at 2:07 pm - Reply

    Great tool. Thank you for sharing.

  7. Abhijit March 30, 2014 at 1:18 am - Reply

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

  8. Sander March 30, 2014 at 3:45 pm - Reply

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

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

    • Mike March 30, 2014 at 3:48 pm - Reply

      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 FilesQlikViewqv.exe).

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

    • Mike March 30, 2014 at 3:50 pm - Reply

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

      Mike

      • Sander March 31, 2014 at 2:45 pm - Reply

        Wright! It’s working now, thanx!

  9. Cotiso January 12, 2015 at 3:03 am - Reply

    Hi,

    I was thinking to add also some QVD contextual options to the same utility.
    The most useful I see now: to create a QVW file with the same name with the QVD file (within the same folder), reload the QVD into the QVW and create at least 2 or 3 sheets:
    – SYS with at least 2 ListBoxes:
    – $Table (& $Rows)
    – $Field
    (first is not very relevant for the first moment, but once created it might be useful to be already there for future QVW developments)
    – ALL DATA with 1 or several multiboxes that allows to navigate through all the data (other options might be also considered, for instance with a dynamic field viewer, that brings getfielddata of selected field)
    – OVERVIEW QVD, with a display of other relevant META INFORMATION from the QVD (file timestamp, file size, folder, any other info that might be available , either from the XML header of the QVD file, or even regarding the creation date of the QVW and last reload time and duration)

    (All provided this should happen provided the QVW with this name doesn’t exist already… in this case just reload & save and keep open of the QVW should be enough…)

    • Mike January 12, 2015 at 8:57 am - Reply

      Hi Cotiso

      These additions will certainly be useful. You can contribute to the code via GitHub: https://github.com/AfterSync/RightQlik

      Miguel

      • Cotiso January 12, 2015 at 9:43 am - Reply

        Hi Miguel,

        My comment was more like a wish-list, rather than a “I wanna start the work”… but who knows… 😉

        Sempre fi,
        C

        • Mike January 12, 2015 at 9:45 am - Reply

          Yeah, well. Maybe someone else can pick this up and consider adding the features you suggest. I just wanted to put the code out there so others could extend it.

          Cheers
          Mike

  10. Lav March 29, 2015 at 8:04 am - Reply

    does it work with 64 bit OS ? I tried and it it kept opening multiple windows for a while and nothing seems to work

    • Mike March 29, 2015 at 9:44 am - Reply

      Hi Lav,

      Yes, the script also works on x64. Are you running the exe as administrator?

Leave A Comment

Sign up to receive updates on new articles

x

If you like this article, consider subscribing to our mailing list to receive updates of new posts right in your email inbox