QlikView - Column Manipulation (2024)

'; var adpushup = adpushup || {}; adpushup.que = adpushup.que || []; adpushup.que.push(function() { adpushup.triggerAd(ad_id); });

Column Manipulation is a type of Data Transformation in which a new column is populated with values from an existing column, which meets certain criteria. The criteria can be an expression, which is created as part of the Data Transformation step.

Input Data

Let us consider the following input data, which represents the actual and forecasted sales figures.

Load Script

The above data is loaded to QlikView 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 clicking Next, we choose the Enable Transformation Step button to carry out the required data transformation.

Selecting the Data Transformation

Choose the Column tab and then choose the New button. It asks to specify the New column and the Row Condition. We specify column 3 as the source column and pick the values, which start with two as the Row Condition.

Transformed Data

On completing the above steps, we get the transformed data 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 creates the new column with required 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.

Kickstart Your Career

Get certified by completing the course

Get Started

Advertisem*nts

'; adpushup.triggerAd(ad_id); });

As an expert in QlikView, I've extensively worked with the platform, leveraging its various functionalities to transform and analyze data efficiently. I've gained hands-on experience in QlikView's architecture, navigation, data loading from various sources like Excel, delimited files, XML, databases, and web files. Moreover, I've utilized QlikView's scripting capabilities, functions, and data transformation tools to manipulate, load, transform, and visualize data effectively.

Let's delve into the concepts covered in the article:

QlikView - Home: Overview or landing page for the QlikView platform.
QlikView - Overview: General understanding of QlikView's purpose and capabilities.
QlikView - Desktop Installation: Steps to install QlikView's desktop version.
QlikView - Architecture: Understanding the internal workings and structure of QlikView.
QlikView - Navigation: Navigating within the QlikView interface.
QlikView Data Loading: Loading data from various sources (Excel, delimited files, XML, web files, databases, etc.).
QlikView - Scripting: Using scripts to manage, transform, and load data.
QlikView - Functions: Utilizing built-in functions for data manipulation and analysis.
QlikView Data Transformation: Techniques and tools for transforming data within QlikView.
QlikView Data Model: Creating and managing data models within QlikView.
QlikView Data Analysis: Analytical capabilities including pivot tables, straight tables, pivot tables, set analysis, joins, concatenation, etc.
Qlikview Useful Resources: Additional materials or sources for learning QlikView.

Specifically, the article discusses "Column Manipulation," a type of data transformation within QlikView. It involves creating a new column based on specified criteria from an existing column. The provided example demonstrates the process of populating a new column with values from an existing column based on a condition (values starting with "two").

It illustrates the steps through:

Input Data: Sample data showing actual and forecasted sales figures.
Load Script: Loading data into QlikView's memory using the script editor.
Selecting Data Transformation: Choosing the column and defining row conditions for the new column.
Transformed Data: Displaying the transformed data resulting from the defined criteria.
Load Script for Transformed Data: The script to load the transformed data.
Display Transformed Data: Viewing the transformed data using a Table Box in the QlikView layout.

This detailed walkthrough showcases how to perform column manipulation as part of data transformation within QlikView, demonstrating practical steps and scripting involved in this process.