Data can be entered into a QlikView document by directly typing or pasting it. This feature is a quick method to get the data from the clipboard into the QlikView. The script editor provides this feature under the Insert tab.

Script Editor

To open the Inline data load option, we open the script editor and go to Insert → Load Statement → Load Inline.

Inserting Data

On opening the above screen, we get a spreadsheet-like document where we can type the values. We can also paste the values already available in the clipboard. Please note the column headers are created automatically. Click Finish.

Load Script

The command, which loads the data, is created in the background which can be seen in the script editor.

Table Box Data

On creating a Table Box Sheet Object, we see the data that is read from the Inline data load option.

QlikView – Scripting

Scripting is a very powerful feature in QlikView, which enables the control of the data load options and data transformations. It enables the use of many inbuilt functions available in QlikView and creates subroutines to be used across multiple scripts within a QlikViewdocument.

Scripting is done using the Script Editor. It is accessed from the File menu using Script Editor. We can also press Control +E to open the script editor window. It prepopulates some data formats that are set as default formats for the data to be processed. For example, the Thousand separator is a comma and date is in Month-day-year format. These can be changed to suit the incoming data as per the need.

Script Editor Features

Script editor has many features, which are accessed from the menu in the script editor window, which is a different menu from the main menu. Given below is a list of important features.

File Menu

Reload − Reloads the script and fetches the new data.
Upper/Lower Case − Converts the case of words as QlikView is case sensitive.
Comment − Used to comment blocks of code.

Edit Menu

Clear Entire Script − Clears the active script tab.
Open Script File − Opens the saved script files.
Table Viewer − Used to see the tabular view of the data being loaded.

Insert Menu

Environment Variables − Inserts a standard list of Environment variables.
Script Files − Allows to browse for script files and insert them.
Connect/Disconnect Statement − Used to connect or disconnect from external databases.

Tab Menu

Insert Tab − Inserts a Tab at the current cursor position.
Promote/Demote Tab − Allows to move the tabs from left to right and vice versa.
Merge with Previous − Used to merge the content of active tag with previous tab.

Tools Menu

ODBC Administrator 64 bit/ODBC Administrator 32 bit − Allows to set the correct DSN information for data sources.
Editor Preferences − Allows you to configure the text font and size, help features, shortcuts, default-scripting engine etc.
Syntax Check − Used to validate the syntax of the script code.

So, this brings us to the end of blog. This Tecklearn ‘Inline Data and Scripting in QlikView’ blog helps you with commonly asked questions if you are looking out for a job in QlikView BI. If you wish to learn QlikView and build a career in Business Intelligence domain, then check out our interactive, QlikView Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/qlik-view-certification-training/

QlikView Certification Training

About the Course

Tecklearn’s QlikView Certification Training will help you become an expert in Data Visualization with QlikView. Learn all the basics and advanced features of QlikView such as data modelling, reports and dashboards, visualization, object formatting, system table etc. Along with this, you will be given hands-on working experience on real-time projects that will help you pass the QlikView certification exam. You also get hands-on experience in QlikView applications.

Why Should you take QlikView Training?

The average annual pay for a QlikView Professional is $122,000. -PayScale.com.
Deloitte, Cisco, Qualcomm, Sony, AON & other top Fortune 500 companies use QlikView
QlikView – A Leader in 2017 Gartner Magic Quadrant for Business Intelligence & Analytics Platforms (For 7th Consecutive Year).

What you will Learn in this Course?

Introduction to QlikView

Concept of Business Intelligence
Features and components of QlikView
Comparison with other BI tools
Architecture
Installation & Navigation
QVS, QVW and .log files
Sheet Objects
Dimensions and Expressions
Various file types and extensions

Various QlikView Products

Overview of the various QlikView products

Introduction to Data and Scripting

Structuring the Script
Create tabs in the scripts, Debugging of scripts
Hands On

Data Model

QlikView Data File Types: QVD, QVX
System fields
Star schema
Synthetic Key Tables
Data Modelling Considerations
Straight and Pivot Table
Hands On

Components of Qlik View

Sheets and Sheet Objects
The List Box
The Table Box
The Multi Box
The Button & Text Object
Basic Charts
Hands On

Set Analysis

Set analysis
Working with modifiers, identifiers, operators, example of expressions,
Indirect set analysis
YTD & MTD

QlikView Functions, Reports and Charts

Uses of Expressions
Chart Properties: Dimensions
Qlikview Functions
Adhoc Reports
Incremental Load using QVD Files
Bookmarks
Hands On

Data Analysis

What-if Analysis
Comparative Analysis
Dynamic Reporting or Ad-hoc Reporting
Document Analyzer

QlikView Security

QlikView security
Defining the access controls and levels of access
Maintaining the access control database

QlikView Administration

QMC (QlikView Management Console)
Server Installation & Deployment
QlikView Project

Got a question for us? Please mention it in the comments section and we will get back to you.

475