Qlik

QlikView/QlikSense Script: Mapping & ApplyMap

MAPPING, ApplyMap: ejemplo // Nota: salto adrede algunos números MiMapa: Mapping LOAD * INLINE [     Codigo, Valor     1, Mercurio     2, Marte     3, Venus     7, Saturno     8, Jupiter ]; TablaSinMapping: LOAD * INLINE [     UnIndice     1     2     3     4     5     6     7 …

QlikView/QlikSense Script: Mapping & ApplyMap Leer más »

QlikView Course Content – Level 2: Developer (16 h)

1. Loading Files and Database Data What is a qvd file? Optimized load Using ODBC and OLEDB Script Checking and Debugging Script control flow (conditional, loops) 2. Associating Data from Several Tables Associations Loading and associating a second table Renaming fields Qualify / Unqualify Mappings Save table to file Resident data source 3. Concatenating Tables …

QlikView Course Content – Level 2: Developer (16 h) Leer más »

QlikView Course Content – Level 1: Designer (16h)

1. Introduction What is QlikView? QlikView Basics Document 2. Query editor: simple data load from file 3. QV Objects 4. Making Queries in a QlikView Document Basic QlikView terminology / colors Associative selections Stepping back or forward in the list of selections Locking and unlocking selections Searching values Selection bookmarks 5. Script Editor Basics: Loading …

QlikView Course Content – Level 1: Designer (16h) Leer más »