- QlikView - Navigation
- QlikView - Architecture
- QlikView - Desktop Installation
- QlikView - Overview
- QlikView - Home
QlikView Data Loading
- QlikView - Data - files(QVD)
- QlikView - Incremental Load
- QlikView - Preceding Load
- QlikView - Resident Load
- QlikView - Inline Data
- QlikView - Database
- QlikView - Web file
- QlikView - XML file
- QlikView - Delimited file
- QlikView - Excel file
QlikView Report Interface
- QlikView - Dashboard
- QlikView - Pie Chart
- QlikView - Bar Chart
- QlikView - Text Object
- QlikView - Multi Box
- QlikView - List Box
- QlikView - Documents
- QlikView - RangeSum Function
- QlikView - Peek Function
- QlikView - Rank Function
- QlikView - Match Function
- QlikView - Aggregate Functions
- QlikView - IntervalMatch
- Qlikview - Functions
- QlikView - Scripting
- QlikView - Sheet and Objects
QlikView Data Transformation
- QlikView - Rotating Tables
- QlikView - Column Manipulation
- QlikView - Fill Function
- QlikView - Transformation Wizard
QlikView Data Model
- QlikView - Generating Data
- QlikView - Synthetic Key
- QlikView - Star Schema
- QlikView - Dimensions & measures
QlikView Data Analysis
- QlikView - Circular Reference
- QlikView - Mapping Tables
- QlikView - Master Calendar
- QlikView - Concatenation
- QlikView - Keeps
- QlikView - Joins
- QlikView - Set Analysis
- QlikView - Pivot Tables
- QlikView - Straight Tables
- QlikView - Cross Tables
Qlikview Useful Resources
- Qlikview - Discussion
- Qlikview - Useful Resources
- Qlikview - Quick Guide
- Qlikview - Questions/Answers
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
QpkView - Database Connection
QpkView can connect to most of the popular databases pke MySQL, SQL Server, Oracle, Postgress etc. It can fetch data and table structures into QpkView environment and store the results in its memory for further analysis. The steps to connect to any of these databases involves creating an ODBC connection using a DSN and then using this DSN to fetch the data.
For this tutorial, we will be connecting to MySQL database. This tutorial assumes you have a MySQL environment available. Create an ODBC DSN (Data Source Name) for MySQL, following these steps −
Name the DSN as mysqluserdsn or you may prefer to use the existing one if you have already created a DSN for MySql.Connecting to the Database
For this chapter we will use the MySql inbuilt database named sakila. We create a new QpkView document and open the script editor (pressing Control+E). Under the tab Data, we locate the section named Database. Choose ODBC from the drop down pst and cpck Connect. The following window opens. Choose the DSN named mysqluserdns and cpck Test Connection. The message Connection Test succeeded should appear.
Verifying Connection to Database
On successful connection, the screen given below appears showing the connection to the DB in the main window of the script editor.
Select Database Table
Cpck Select iin the above window to get the pst of tables and columns. Here as we have created the DSN with sakila as the default database we get the pst of tables and columns from this database. We can choose another database from the database drop down pst as shown in the screenshot given below. We will continue using the sakila database for this chapter.
Table Loader Script
On Cpcking OK in the above window, we get back to the main script editor showing the script for using the table named actor.
Showing the Result in qvd File
Now the data loaded into QpkView document needs to be stored permanently to be analyzed further. For this, we will edit the script to store the data in the form of a qvd file. Press Control+E to open the edit script window and write the following code.
In the code, we give appropriate names to the columns and mention the table name above the load statement. In addition, we give a path where the generated qvd file will be stored. Save this file as QV_mysql.qvw
Using the qvd File
The qvd file can be loaded into the main document and used to create graphs and tables for further analysis. Press Control+R to reload the QV_mysql.qvw file and cpck Next in the chart wizard. Choose the straight table to be created with actor_id, first_name, last_name as the dimensions and count of actor_id as the expression. A chart appears as given below.
Advertisements