Qlik View 101

QV: Hierarchy

2011-10-11T01:53:00.001-07:00

EMPLOYEE_MGR:
hierarchy (EMPLOYEE_KEY,MGR_ID,EMPL_NAME,,EMPL_NAME,EMPLOYEE_MGRPath,'|')
LOAD "EMPLOYEE_KEY",
    "EMPL_NAME",
    "POSTN_KEY",
    "HIRE_DT",
    "MGR_ID",
    EMPLOYEE_TYPE;
SQL SELECT
    "EMPLOYEE_KEY",
    "EMPL_NAME",
    "POSTN_KEY",
    "HIRE_DT",
    "MGR_ID",
    TYPE as EMPLOYEE_TYPE
FROM BISAMPLE."SAMP_EMPL_D_VH";

Listbox > show as treeview > set Separator

QV: Join

2011-10-10T05:15:00.001-07:00

Join are based on the Column name ==> Same Column in different tables is a join.

Till Next Time

QV: Design Toolbar

2011-10-10T03:45:00.001-07:00

View > Toolbars > Design

Till Next Time

QV: Moving a sheet object

2011-10-10T03:40:00.001-07:00

To move a sheet object you select it with the mouse button, then keep the
mouse button depressed while dragging it.
To move a sheet object step by step, use CTRL+arrow. For bigger steps, use
CTRL+SHIFT+arrow.

Till Next Time

QV: Wildcard searches

2011-10-10T03:32:00.001-07:00

Qlikview uses the “*” as main wildcard character. ==> “*s”,”s*”,”*s*” (Case insensitive)

Till Next Time

QV101 Welcome to Qlikview101

2011-10-10T03:20:00.001-07:00

I will put stuff I find during my Qlikview research here.