Show Menu

Qlikview v10 Reference Keyboard Shortcuts by

Reference cheat sheet for Qlikview : shortcut keys, tips and tricks, examples
qlikview     bi     keyboard     business     intelligence

Qlikview v10 file handling

New document
Ctrl+N
Open Document
Ctrl+O
Open Document on server
Ctrl­+S­hift+N
Save Document
Ctrl+S
Save Document as
F12

Qlikview v10 selection keys

Open Current Selections view
ctrl + Q
Back in selections
shift + lefta­rrow
Forward in selections
shift + right­arrow
Lock the object selection
ctrl + L
Lock all selections
ctrl + shift + L
Uock the object selection
ctrl + U
Unlock all selections
ctrl + shift + U
Clear (D­elete) the object selection
ctrl + D
Clear (D­elete) all selections
ctrl + shift + D

Qlikview v10 edit shortcut keys

Undo layout change
Ctrl + Z
Redo layout change
Ctrl + Y
Cut
Ctrl + X
Copy
Ctrl + C
Paste
Ctrl + V
Remove
Del
Activate All
Ctrl + A
Find
Ctrl + F
Advanced Find
Shift + Ctrl + F

Qlikview v10 F Keys

Activates context sensitive help
F1
Enters search mode
F3
Activates the sheet tab to the left of the active one
F6
Activates the leftmost tab
ctrl + F6
Activates the sheet tab to the right of the active one
F7
Activates the rightmost tab
ctrl + F7
Save as
F12
 

Qlikview v10 actions keys

Print document
ctrl + P
Print as PDF
ctrl + shift + P
Edit script
ctrl + E
Reload data
ctrl + R
Partial reload data
ctrl + shift + R
Table viewer
ctrl + T
Show/Hide grid
ctrl + G
Open User Prefer­ences
ctrl + alt + U
Open Do­cument Properties
ctrl + alt + D
Open Sheet Properties
ctrl + alt + S
Open Va­riable Overview
ctrl + alt + V
Open Ex­pre­ssion Overview
ctrl + alt + E
Properties of the selected object(s)
alt + enter
Edit Module
ctrl + M
Alerts
ctrl + alt + A
Add Bo­okmark
ctrl + B
More Bo­okmark
ctrl + shift + B

Qlikview v10 set analysis identi­fiers

0
Empty set
1
Full set of all the records
$
Current selection
$1
Previous selection
$_1
Forward selection
Bookmark01
Bookmark ID or name

Qlikview v10 set analysis operators

+
Union
-
Exclusion (first but not the other)
*
Inters­ection (both)
/
Symmetric difference (either but not both)

Qlikview v10 set analysis modifiers

<Or­derDate = Delive­ryD­ate>
Select only data where field1 = field2
<Field = {value­}>
Select specific value
<Region = >
Ignore the specific field
<Ye­ar=­{2000}, Region = {"U*­"­}>
Two fields can be filtered, with wildcards
 

Qlikview v10 script edition keys

Go to line number in the script
ctrl + G
List of keyboard shortcuts
ctrl + Q,S,C
Co­mment lines in script
ctrl + K,C
Un­comment lines in script
ctrl + K,U
Add tab in script
ctrl + Q,T,A
Pr­omote active tab
ctrl + Q,T,P
Demote active tab
ctrl + Q,T,D
Rename active tab
ctrl + Q,T,N
Remove active tab
ctrl + Q,T,R
Creates an autoge­nerated script
ctrl + Q,Q
Opens Un­icode input utility
ctrl + Q,U,I
Creates a script for reading jpg attributes
ctrl + Q,J,P,G
Creates a script for reading mp3 attributes
ctrl + Q,M,P,3
Creates a script for reading wma attributes
ctrl + Q,W,M,A
ctrl + K,C means ctrl + K then ctrl + C

Qlikview v10 set analysis examples

sum(sales) or sum({$} sales)
sales in current selection
sum({1} sales}) or sum({1} Total sales})
sales disreg­arding the selection or disreg­arding selection and dimension
sum({$­<Or­derDate = Delive­ryD­ate­>} sales)
sales in current selection for a specific date
sum({1­<Region = {US}>} sales)
total sales for region=US
sum({<­Region = >} sales)
sales in selection with region removed (idem $)
sum({$­<Ye­ar=­{2000}, Region = {"U*­"­}>} sales)
current selection but year forced to 2000 and region like U*
sum({$­<Year = {$(vLa­stY­ear­)}>} sales)
sales related to a variable
p({<Ye­ar=­{$(­=ma­x(Y­ear­)-1­)}>} customer)
returns customers who are possible for last year
e({<Ye­ar=­{$(­=ma­x(Y­ear­)-1­)}>} customer)
returns customers who are excluded for last year

Download the Qlikview v10 Reference Keyboard Shortcuts

2 Pages
//media.cheatography.com/storage/thumb/fredv_qlikview-v10-reference.750.jpg

PDF (recommended)

Alternative Downloads

Share This Cheat Sheet!

Like this cheat sheet? Check out our sponsors!

Readability-Score.com is a collection of tools to make your writing better. More readabile content means higher conversion rates and better reader engagement. Measure website and document readability, measure keyword density and more!

Click Here To Get Started!

 

Comments

DaveChild DaveChild, 10:02 28 Nov 11

Brilliant cheat sheet, fred! You're on a roll! :)

Thomas Geßler Thomas Geßler, 11:16 2 Jan 13

great stuff
but there is something import missing (an also a little mistake) in the QlikView Set Analysis Examples:

sum({1} sales}) .. only disregarding the selection (so not total)

missing:
sum({1} Total sales) .. disregarding the selection and dimension

maybe you can fix it
thanks

fredv fredv, 16:13 11 Jan 13

Thanks
fixed

Thomas Geßler Thomas Geßler, 11:48 24 Jan 13

great stuff, thanks !
but please fix:
sum({1} sales) .. only disregarding selection
and please add:
sum({1} total sales) .. disregarding both selection and dimension

gabriel gabriel, 20:41 25 Feb 15

excellent!!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          VLC (Windows & OS X) Keyboard Shortcuts
          Sublime Text 2 Windows Keyboard Shortcuts

          More Cheat Sheets by fredv

          EQ tips Cheat Sheet
          Gmail Keyboard Shortcuts
          Google Documents shortcut keys Cheat Sheet