Top 5 Little Known QlikView Shortcuts

QlikView Shortcut - Featured Image - Street Signs with Windows Shortcuts

In this post, I wanted to highlight a few little-known QlikView shortcuts.  Everybody is familiar with Ctrl-E to edit script or Ctrl-R to reload our application.  But lets take a look at a few shortcuts that you might not know about that provide some quick and cool functionality.  We will do this in reverse order for dramatic effect 😉

5.  Move locked objects: Alt-Drag

If you ever lock down your objects (Properties –> Layout –> Uncheck Allow Move/Size) then you know that you have locked their movement even for you, the developer.  Instead of checking this option again for all your objects, you can simply hold down Alt and drag your object wherever it is needed. 

4.  Comment & Uncomment: Ctrl-K-C / Ctrl-K-U

I am a fan of comments both in the script and in front end expressions.  These comments can help the next developer figure out why you did something, or far more likely, remind YOURSELF of what YOU did 3 weeks ago in this application.  Most people are familiar with highlighting text, right clicking and selecting comment or uncomment.  But the keyboard shortcut Ctrl-K-C will comment highlighted lines and Ctrl-K-U will uncomment the selection. 

3.  Activate previous or next sheet: F6 / F7

If you are progressing sequentially through the sheets of an application, F7 will save you a click as you proceed rightward from one sheet to the next.  F6 will move you backwards or right to left.

2.  Object properties:  Alt-Enter

Probably one of the most frequent operations is right clicking on an object and selecting properties.  There’s a shortcut for that.  You still must activate the object with a click, but then Alt-Enter will get you to the properties.  That’s a time-saver for sure.  If no object is selected it will invoke the sheet properties similar to if you right click in open space and select properties.

1.  Generate sample data: Ctrl-Q (2x)

Maybe not as usable as the previous, but this one takes the top spot for sheer cool factor.  Go to the script editor, and tap Ctrl-Q twice.  This will generate some scripting that, when reloaded, will create three tables of associated sample data for you to test with.  The script requires no outside files to run and will generate about 2,000 rows of transactions for you with a couple associated dimension tables. 

I compiled a few articles that cover some other great QlikView Shortcuts:

Qlik Pad – QlikView Designer Shortcuts

QlikPad – QlikView Editor Shortcuts

BI Review – Hot Keys in QlikView

Please feel free to gloat if you knew these already.  Or I would be happy to hear about any other really cool QlikView shortcuts you have uncovered in your experience. 

4 comments… add one
  • Reply Sébastien FATOUX July 4, 2014, 8:33 pm

    Hi Aaron,
    I knew only the 4th and the 1st.

    But I know one that is very cool to know a lot of other

    CTRL-E (to go to the editor) and after that CTRL-Q-S-C (for Qlikview ShortCut) and you will see a lot of shortcut

    Regards

  • Reply Aaron Couron July 5, 2014, 3:42 pm

    I saw the shortcut to get to this screen but did not realize you had to go to script editor first to see it. Pretty awesome.

  • Reply Abhijit July 25, 2014, 7:04 am

    Many thanks Aaron for sharing this.
    I knew only 1st (Ctrl+Q)2x.
    3rd (F6/F7) is a showstopper for me.

    ———-
    Abhijit

  • Reply MohamedJubair January 7, 2015, 10:05 am

    Thanks for the info. on shortcuts.I am amazing about QlikView because it is capable of bringing wonderful insights on different niches and it is the most favored business intelligence tool for industries like Education, Retail, HealthCare and Insurance

Leave a Comment

Join us at Living QlikView

Never miss a post.

We Never Spam. NEVER.

Show Buttons
Hide Buttons