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

  • Opening the document
  • Automatic concatenation
  • Forced concatenation

4. The Data Model

  • Using the Table Viewer: table and field information available
  • Labeling tables in the script

5. Hierarchical Data & List Box

  • Loading hierarchical data
  • Setting Listbox presentation as hierarchical

6. Dollar sign expansion revisited

  • Using Expressions
  • Dollar sign Expansion
  • Using Variables to store expressions

7. Load Inline

  • Adding a record with load inline
  • Adding a table with load inline

8. Loading Additional Files

  • Loading a tab separated file without labels
  • Loading a file via OLE DB

9. Linking External Information to a Document

  • Looking at an info table
  • Loading the info table
  • Viewing the linked information
  • Embedding external info
  • Displaying info in a text object

10. Advanced Object parametrization

  • Field groups
  • Cyclic display of expressions
  • Showing data as image

11. Advanced calculations: Set Expressions

  • All records Data Set
  • Selected records Data Set
  • Filters in set expression
  • Set operations

12. Alternate States

  • Enabling alternate sets
  • Setting alternate states
  • Using alternate states in objects and expressions

13. Number Formats

  • Handling of numeric data
  • Interpretation of numeric data
  • Formatting of data
  • Type conversion

14. Actions

  • Simple Actions
  • Assigning a value to a variable
  • Writing and Executing a Macro – QV API Object Model

15. Layout Themes

  • Using an existing theme
  • Theme structure
  • Creating a theme
  • Applying a theme

16. Security

  • Sections in the Script
  • Access levels
  • Security fields
  • Loading security tables
  • Using the Security pages
  • Field restriction and values restriction
  • Opening a document with access restriction: data reduction
  • Sheet security

17. More about Associations

  • Creating a system sheet
  • Using the system sheet
  • Creating a system table
  • Showing frequency in key fields

18. Incremental Loads, partial loads

Deja un comentario