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
Join are based on the Column name ==> Same Column in different tables is a join.
Till Next Time
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
Qlikview uses the “*” as main wildcard character. ==> “*s”,”s*”,”*s*” (Case insensitive)
Till Next Time
