- 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 - Rotating Tables
The Rotating table in QpkView is similar to the column and row transpose feature in Microsoft Excel but with some additional options. We can transpose columns in multiple directions and they give different results. In this chapter, we will be seeing the normal transpose option of converting rows to columns.
Input Data
Let us consider the following input data, which represents the actual and forecasted sales figures.
Month,Forecast,Actual March,2145,2247 April,2458, May,1245, June,5124,3652 July,7421,7514 August,2584, September,5314,4251 October,7846,6354 November,6532,7451 December,4625,1424 January,8547,7852 February,3265,
Load Script
The above data is loaded to QpkView memory by using the script editor. Open the script editor from the File menu or press Control+E. Choose the "Table Files" option from the "Data from Files" tab and browse for the file containing the above data.
After cpcking Next, we choose the Enable Transformation Step button to carry out the required data transformation.
Selecting the Data Transformation
As we are going to use the Rotate function, let us choose the Rotate tab which displays the values of all the fields.
Apply Rotate
We cpck the Transpose button to transpose the above data. The transposed data appears as shown below.
Load Script for transformed Data
The load script for the Transformed data can be seen using the script editor. The script shows the expression, which replaces the empty cell values.
Display Transformed Data
The transformed data can be seen by creating a Table Box using the option in the menu Layout → New Sheet Object.
Advertisements