Blog

Qlikview Mapping

  • (4.0)
  •   |   562 Ratings

Qlik is a software company that provides a Business Intelligence softwares named as QlikView and a data visualization software called Qlik Sense. It is basically from Sweden but now it is headquartered at United States. QlikView is a self service Business Intelligence where organization users can view data on fly. The data exploration given by QlikView is available to multiple users.

Data Mapping in DataBase:

It is a process of creating data elements from two distinct data data models for the purpose of data transformation kind of data integration tasks.

Learn how to use QlikView, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free QlikView Training Demo!

QlikView Mapping:

If you want to map countries and top performer in outside sales in every location of an organization can be done within no time.

An enterprise has multiple  locations say USA , India, UK, Australia. Individually, within the country, there are multiple centers. Let’s say in India, there are 3 centers - Hyderabad, Delhi and Pune. Each center has 300 outside sales representatives working on different products. Individually, every center maintains the performance of each outside sales representative in a data sheet.  Now, selecting the top performer over a country wise and continent wise requires the top management to collect data from different units and then to analyse them to find the best one.  Using QlikView , all the data is integrated and analysed based on the questions the user raised and outputs the results.

One can get the Top performers of an enterprise from each organization or center as

“Salesman Name  ||  Country”

This output is attained with a simple Syntax:  Mapping( loadstatement | selectstatement ).

There are many functions available in this Mapping technique to handle the database table mapping.

Mapping tables or Mapping load serves as an alternative to Join statement in database. Mapping to the load statement tells Qlikview that a table is Mapped with another. A mapping table can have 2 columns-  the lookup value and the mapping value. Mapping Tables are  temporary tables as they are  automatically removed from the data model by the end of execution of the script.

Frequently Asked QlikView Interview Questions & Answers

Applymap() function:

The function is used for mapping an expression to those stored mapping table.

The syntax is: applymap('mapname', expr [ , defaultexpr ] )

mapname is the name of a mapping table.
expr is the expression.
defaultexpr is an expression which is used as a default mapping value if the mapping table does not contain any value for expr. If no default value is given, the value of expr will be returned as it is.

Syntax and Use case of Mapping Tables

For a invoice dictory, when we need to calculate the total invoice amount, the due amount and the final payment etc. in a retail store .We will maintain the data table that contains  customer selected items, an InvoiceID, amount received.

Related Page: Process Of Incremental Load In QVD QlikView

The Mapping Table or Mapping Load function is created by the following syntax.

Map_ReceiptAmount:
Mapping Load
   Invoice ID as ReceiptInvoiceID,
   Amount as  Receipt Amount
From
{ data source}

From the above commands, we are creating a Mapping table with Invoice IF and Amount received. Place where the datatable stored in the system.

Now we use ApplyMap function on the above tale wit the syntax below.

ApplyMap (‘Map_ReceiptAmount’,InvoiceID,0)

Load the required information like Mapping table, the key field and the default value. The full script can be:

(InvoiceDetails) :
LOAD InvoiceDetailID,
          Description,
          InvoiceID,
          ApplyMap (‘Map_ReceiptAmount’,InvoiceID,0) as ReceiptAmount
FROM    
{ Destination source file }

You can see the result with new column ReceiptAmount added to the invoice table.

Features of QlikView Mapping

  • Mapping Table are like Lookup Function which takes an input value, checks if this value exists in a mapping table and returns it to 2nd column of the mapping table.

  • First a Mapping table is created and then a Map is applied on it.

  • A Map is held in the memory until the script runs. It is collapsed after that making it as a temporary table.

  • The temporary stay nature of the mapping table does not affect the main data.

  • They can be reused as and when needed for multiple times in a script.

  • Mapping table  has the first field as the Key and second field as the mapped value  ALWAYS.

  • When referring a Map name, single script is used.

  • We can translate the map for multiple times.

Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules