Show Menu

Qlikview v10 Reference Cheat Sheet by fredv

Reference cheat sheet for Qlikview : shortcut keys, tips and tricks, examples

Qlikview v10 file handling

New documentCtrl+N
Open DocumentCtrl+O
Open Document on serverCtrl­+S­hift+N
Save DocumentCtrl+S
Save Document asF12

Qlikview v10 selection keys

Open Current Selections viewctrl + Q
Back in selectionsshift + lefta­rrow
Forward in selectionsshift + right­arrow
Lock the object selectionctrl + L
Lock all selectionsctrl + shift + L
Uock the object selectionctrl + U
Unlock all selectionsctrl + shift + U
Clear (D­elete) the object selectionctrl + D
Clear (D­elete) all selectionsctrl + shift + D

Qlikview v10 edit shortcut keys

Undo layout changeCtrl + Z
Redo layout changeCtrl + Y
CutCtrl + X
CopyCtrl + C
PasteCtrl + V
RemoveDel
Activate AllCtrl + A
FindCtrl + F
Advanced FindShift + Ctrl + F

Qlikview v10 F Keys

Activates context sensitive helpF1
Enters search modeF3
Activates the sheet tab to the left of the active oneF6
Activates the leftmost tabctrl + F6
Activates the sheet tab to the right of the active oneF7
Activates the rightmost tabctrl + F7
Save asF12
 

Qlikview v10 actions keys

Print documentctrl + P
Print as PDFctrl + shift + P
Edit scriptctrl + E
Reload datactrl + R
Partial reload datactrl + shift + R
Table viewerctrl + T
Show/Hide gridctrl + G
Open User Prefer­encesctrl + alt + U
Open Do­cument Propertiesctrl + alt + D
Open Sheet Propertiesctrl + alt + S
Open Va­riable Overviewctrl + alt + V
Open Ex­pre­ssion Overviewctrl + alt + E
Properties of the selected object(s)alt + enter
Edit Modulectrl + M
Alertsctrl + alt + A
Add Bo­okmarkctrl + B
More Bo­okmarkctrl + shift + B

Qlikview v10 set analysis identifiers

0Empty set
1Full set of all the records
$Current selection
$1Previous selection
$_1Forward selection
Bookmark01Bookmark 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 scriptctrl + G
List of keyboard shortcutsctrl + Q,S,C
Co­mment lines in scriptctrl + K,C
Un­comment lines in scriptctrl + K,U
Add tab in scriptctrl + Q,T,A
Pr­omote active tabctrl + Q,T,P
Demote active tabctrl + Q,T,D
Rename active tabctrl + Q,T,N
Remove active tabctrl + Q,T,R
Creates an autoge­nerated scriptctrl + Q,Q
Opens Un­icode input utilityctrl + Q,U,I
Creates a script for reading jpg attributesctrl + Q,J,P,G
Creates a script for reading mp3 attributesctrl + Q,M,P,3
Creates a script for reading wma attributesctrl + 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
 

Share This Cheat Sheet!

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

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.