Advanced Scripting with Qlik Sense

This project include; Transforming data, Using the Crosstable prefix, Combining tables with Join and Keep, Using inter-record functions: Peek, Previous, and Exists, Matching intervals and iterative loading, Data cleansing, Handling hierarchical data, QVD files. More detailed information on the subject can be found in this report.

Advanced Scripting Tutorial.qvf

Loading data using the Crosstable prefix, combining tables using Join, using inter-record functions Peek and Previous.

Advanced Scripting Tutorial-2.qvf

Loading data grouping People and Ages with using Exists() and Dual() functions.

Using IntervalMatch prefix.qvf

Loading data using IntervalMatch() prefix with While loop and iterative loading IterNo().

Using Mapping prefix.qvf

Loading data using Mapping functions; Mapping prefix, ApplyMap(), MapSubstring(), Map … Using statement, Unmap statement

Using Hierarchy prefix.qvf

Loading data using Hierarchy prefix, HierarchyBelongsTo prefix

Using Buffer.qvf

Creating QVD file using Buffer prefix.