Tuesday, October 11, 2011

QV: Hierarchy

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

Monday, October 10, 2011

QV: Join

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

Till Next Time

QV: Design Toolbar

View > Toolbars > Design

image

Till Next Time

QV: Moving a sheet object


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

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

Till Next Time

QV101 Welcome to Qlikview101

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