Qlikview Interview Questions

What are the unique features of QlikView?

(a)Data Association is maintained automatically. (b) The structure, data and calculations of a report are all held in the memory (RAM) of the server. (c) Data is compressed to 10% of its original size. (d) Visual relationship using colors.

What is Incremental Load?

The concept of loading only the new or changed records from the source into the QlikView document is called Incremental Load.

How you connect QlikView to Database?

QlikView can connect to data base using ODBC connection created for the database.

What is Dashboard?

A dashboard is a QlikView document which shows many matrices together and the values in the sheet objects can change dynamically upon selection of certain value in one of the Sheet Objects.

Define Trellis chart?

In Trellis chart we can create array of chart based on first dimension. Bitmap chart are also made of trellis display.

Explain Mini Chart?.What do you mean by sub reports and how we can create them?

With the help of Mini Chart we can set type of modes instead of values in table mode. We can also change the colors.

What is Pivot Table?

Pivot Table:
A pivot table is better at the time of grouping. We can also show pivot table like a cross table which is a beneficial feature. But there is one disadvantage of it which is if we have to sort a pivot table than we have to sort it first according to the first dimension then to the next.

Which graph we will use for two years difference sale ?

BAR Graph we will use.

What is Straight Table?

A straight table is much better at the time of sorting as compared to the pivot table as we can sort it according to any column as per our choice. But it is not good for grouping purpose.

How many dimensions we can use in Bar chart?

We can use only two dimension.

Which Qlikview object has only expression and no dimension?

Gauge chart and list box have only expression and no dimension.

How we can use Macros in our application?

We can use macros for various purposes like for reloading the application and to create object.

What do you understand by layers in Qlikview?

The layer are basically set on the sheet object properties layout where bottom, top, normal respective to the number -1,0 and 1.

What is Dimensions?

Dimensions allow data examination from various perspectives.

Explain about Normalized Data?

Well Structured Form of Data, which doesnt have any repetition or redundancy of data. It’s a kind of Relational data. It’s mainly used in OLTP kind of stuffs Denormalized Data – It’s a whole bunch of data without any relationship among themselves, with redundancy of data. It’s mainly used in OLAP kind of stuffs.

What Is Star Schema ?

The simplest form of dimensional model, in which data is prearranged into facts and dimensions is known as Star schema.

What is Snowflake Schema ?

A snowflake schema is a difference of the star schema. Snowflake is used to improve the presentation of particular queries.

Explain interval match?

The internal match is prefixes with the load statement which is used for connecting different numeric values to one or more numeric interval.

Explain internal match function()?

Internal match function is used to generate data bucket of different sizes.

What is Container ?

A container object is used to keep multiple charts. We can use a container object to keep many charts in the same box.

What do you understand by extended interval match function()?

Extended interval match function() is used for slowly changing the dimensions.

What are the new features in QV 11?

Container Object;Granular Chart Dimension Control; Actions like, clear filed; meta data,etc are the new features in QV 11. 

Explain joins and its types?

Join is used to convert the given data and whenever we are using joins for converting data its is known ad Data Merging.
It has many types:
a. Left join
b. Right join
c. Inner join, etc

What is Left Join?

Left join specifies that the join between the two tables should be left join, it uses before the word join. The resulting table only contain the combination among two tables with the full data set from the first table.

Define right join?

Right join specifies that the join between the two tables should be right join, it uses before the word join. The resulting table only contain the combination among two tables with the full data set from the second table.

Explain Inner Join?

Inner join specifies that the join between the two tables should be inner join. The resulting table should contain the full data set from both the sides.

What are modifiers?

Modifiesr deals with the Fields name.
For example: sum({$<Region=>}Sales)
Returns the sales for current selection, but with the selection in “Region” is removed.

Explain Identifiers Syntax?

Represents the empty set
Represents the full sets of records
$-Represents the record of current selection
$1-Represents the previous selection
$_1-Represents the next selection
Bookmark01-Represents the Bookmark name

Explain 3-tier architecture of Qlikview Application?

1-tier: Raw data is loaded and we create QVD
2-tier: QVD is converted in business login and the requirement of business and data model is created.
3-tier: Reading all QVD from 2-tier and we make a single QVW

How does Qlikview stores the data internally?

Qlikview stores the data in QVD as QVD has data compression capability. Qlikview has better performance than other BI because of its memory analytics approach.

Explain the restrictions of Binary load for a QlikView Developer?

Binary Load can be used for only one application means we can only read the data from one QVW application and moreover set scripts is also a restriction.

For a QlikView Administrator, differentiate between subset Ratio and Information Density?

Subset Ratio: It is used for easily spot problem in key field association.it is only relevant for key fields since they are present in multiple tables and do not share the same value.
Information Density: It is the field which contain the percentage of row which contain the non-null value.

What is the use of Optimized Load?

Optimized load is much faster and preferable especially for large set of data. It is possible if n o transformation are made at the time of load and no filtering is done.

Differentiate between keep and joins?

Keep and joins do the same functions but in keep creates the two tables whereas join only creates the one table. Keep is used before the load or select statements.

Define synthetic Key?

Synthetic key is the key where two or more tables consists more than one common column between them is called as synthetic key.

What is incremental load in Qlikview Architect?

Incremental load is nothing but loading new or changed records from the database. With the help of QVD files we can use incremental Load.

Differentiate between set and let option in Qlikview?

Set: it assigns the variable without assesses the expression.
Let: it assigns the variable with assesses the expression.

Define Qlikview Resident Load?

Resident load is a part of loading data in Qlikview application. It is used for loading data in tables which is already loaded in Qlikview application.

How we can optimize QV application?

It can be optimized by creating the data into qvds. When complete qvw application is changed into qvd than this qvd will be store in the RAM

What is mapping load?

Mapping load is used to create the mapping table that can be used for replacing field value and field names.

Define apply map?

apply map is used to add fields to the tables with the help of other tables. It can be used as joins.

What is concatenation?

It means sequence of interconnected things i.e. any column or row which is related to each other can be connected through concatenation.

Define NoConcatenation?

NoConcatenation prefix is used to force the identical tables as two separate internal tables.

Define connect statement?

It is used to establish a connection to database with the help of ODBC or OLEDB interface.

What do you understand by Fact constellation Schema?

It is a logical database structure of data Warehouse . It is designed with the help of De Normalized Fact.

What do you mean by RDBMS?

It stands for relational Database management System. It arranges the data into respective column and rows.

What do you understand by the term CAL in Qlikview Server?

Every client needs a CAL to get connected with Qlikview Server. The CALS are taken up with Qlikview Server and tied with the server serial number.

Differentiate between QV server and publisher?

QV Server is a program that is installed on computer with various CALS which allow user to access QV Files on the server. Publisher is a program which manages centralized control on our QV files and manages them how and when they are loaded and distributed.

What do you understand by snapshot view of the table?

By this option we can see number o tables and related associations.

How we can bring data into qv?

We use ODBC, OLEDB, SAP connectors kind of data connections.

How we can handle Early Arriving Facts?

We can load data from ODBC, OLEDB, SAP connectors , by select statements and we can also load files like excel, word, etc. by using Table Syntax.

What type of data we generally use?

We use flat files, excels, QVDs, etc ad data.

Explain about QlikView?

QlikView is the Business Intelligence tool used by the University of St Andrews. Data from different University systems is combined and presented in a single dashboard in an easy and understandable way.

QlikView dashboards at the University of St Andrews are built on the following principles:
Dashboards must be effective to use
Dashboards must support users in carrying out their tasks
Dashboards must provide the right kind of functionality
It must be easy to learn how to use a dashboard
It must be easy to remember how to use a dashboard
To use QlikView, you do not need to have technical expertise in information systems, just a willingness to learn how it can support you.

What are the benefits of using QlikView?

As the name suggests, QlikView is a combination of quick and click and these features make it intuitive and easy to use. Users can visualize data, search multiple data sets, create ad hoc reports, and view patterns and trends in data that may not have been visible in other reports.
QlikView is

Flexible – dashboards are web based and accessible from desktop computers and mobile devices
Interactive – users are able to drill down and select particular data within charts or tables
Usable – users can see large amounts of data effectively and efficiently
Scalable – useful for multiple business processes at analytical, operational and strategic levels

How is QlikView 11 different from QlikView 10?

QlikView 11 brings new levels of capability and manageability to the QlikView Business Discovery platform. In this release, we focused our investments on five value propositions:
Improve collaborative decision making with Social Business Discovery
Gain new insights into opportunities and threats and relative business performance with comparative analysis
Expand QlikView usage to additional devices, including smartphones, with mobile Business Discovery
Enable a broad spectrum of users to jointly develop QlikView apps with QlikView’s rapid analytic app platform capabilities
Improve the manageability and performance of QlikView with new enterprise platform capabilities.

What is QlikView comparative analysis in QlikView Developer platform?

Business users can quickly gain new kinds of insight when analyzing information in QlikView, with new comparative analysis options. QlikView App developers can now create multiple selection states in a QlikView app; they can create graphs, tables, or sheets based on different selection sets.

What mobile device platforms does QlikView 11 support?

QlikView 11 delivers mobile functionality for Apple iOS and Android tablets and smartphones. QlikView supports Android tablets when the following conditions are met:
QlikView Server version 10 SR3 or later
The native browser, not a downloaded one
Currently our HTML5 web apps support only Apple and Android handhelds. Because many Black Berry are older devices that don’t fully support HTML5 (and many are non-touch), we don’t have a web-based solution for them at this time.

For QlikView Admin, what is document-level auditing in QlikView 11?

New optional settings within QlikView Management Console enable administrators to more effectively audit user interactions. Administrators can audit QlikView usage not only at the system level (the entire QlikView Server), but down to the document level.

What are the key differences between QlikView and any other standard statistical software package (SAS, SPSS)?

Key difference is in terms of the database used. QlikView offers a quite simple visualization that matches the MS excel filtering. SAS is useful in case of Meta data while SPSS is good for analysis.
In comparison of the above three, QlikView is most user friendly and fast in terms of generating diverse dashboards/templates.
In terms of calculations, advanced statistics options are limited in QlikView.
For market research and analysis SPSS has direct facility algorithms.

What are QlikView annotations?

With the new annotations collaboration object QlikView users can engage in threaded discussions about QlikView content. A user can create notes associated with any QlikView object. Other users can then add their own commentary to create a threaded discussion. Users can capture snapshots of their selections and include them in the discussion so others can get back to the same place in the analysis when reviewing notes and comments. QlikView captures the state of the object (current selections), as well as who made each note and comment and when, for a lasting record of how a decision was made.

What are the main features of QlikView?

QlikView offers the following features:
Dynamic BI Ecosystem
Data visualization
Interacting with dynamic apps, dashboards and analytics
Searching across all data
Secure, real-time collaboration.

What are the differences among QlikView Server editions?

The differences are:
QlikView Server Enterprise Edition (EE) is available for customers looking to support a large number of users and integrate into enterprise environments. It includes features such as:
Unlimited documents
Integration with third party security systems
Server clustering
Small Business Edition (SBE) is designed to be used in smaller deployments.
It has the following limitations:
For use only with Named and Document CALs
Limited to 25 Named User CALs
Limited to 100 Document CALs
No support for additional servers
Only supports Windows Active Directory to handle security and access control
Information Access Server (IAS) is an edition of QlikView Server designed to power public Internet sites. This edition:
Includes the add-on QlikView Real Time Server
Is licensed for uncapped number of user but limited to one QlikView document
Must be set to anonymous mode only and authentication must be off
Requires that the QlikView server be on the public Internet and publicly accessible
Requires that the URL for accessing the site powered by the QlikView Server be publicly accessible
Requires that no QlikView client (e.g., QlikView Desktop, Internet Explorer plug-in, Ajax) can access the QlikView Server (all user interfaces must be built by the customer manually or with QlikView Workbench)
QlikView Extranet Server (QES) is an edition of QlikView Server designed to extend QlikView functionality to external users via an extranet. QES:
Requires authentication. Users must be external to the purchasing organization (customers, partners, etc.).
Restricts server access to the Ajax client and mobile clients
Provides the option to customize the QlikView application via the included QlikView Workbench
Supports a maximum of 3 QlikView documents
Supports session CALs and usage CALs only.

What is Aggr Function?

AGGR statement function produces a virtual table, with one expression and grouped by one or more dimensions. The result of this virtual table can then be used by a further outer aggregation function(s).

What is a star schema?

A Star schema is a data model in which one fact table is connected to multiple dimension tables though foreign keys

What is the difference between Join and Keep?

In case of keep both the datasets are available in QlikView’s memory while in join the load statements produce only one data set from which you have to choose the columns. Also there is no concept of outer keep where as we have outer join available in case of joins.

What is Synthetic key, is it good or bad to have?

QlikView creates a synthetic key when two or more column between tables are same. It does not impact the data or performance but it indicates a flaw in the data model design.

Difference between Join and Concatenate?

Join gives the resulting records from two tables as records containing columns form both tables. But Concatenate only appends the rows from one table with another.

What are Circular loops in QlikView?

A circular loop is created when the relationship between two tables can be established both directly and through another third table.

What does MonthStart function do?

Returns a value corresponding to a timestamp with the first millisecond of the first date of the month containing date.

What does Autogenerate Function do?

This function auto generates values between a given range of numbers.

What is a pivot table in QlikView?

Pivot Tables are used to present sum of values across many dimensions available in the data. For example showing the total sales figure for both the months and quarters in a years.

What are the 6 chart types available in QlikView?

Bar Chart, Pie Chart, Line Chart, Gauge Chart, Pivot table, Straight table.

Can QlikView extract data from website? How?

Yes. In QlikView script editor we have the option to extract data form a web file by giving the URL as the input.

What is the use of Promote/Demote options in a Table Box property?

It allows you to rearrange the columns in the Table box which is displayed in the Sheet.

What are the three options available under the Rotate table functionality for data transformation?

Rotate Left, Rotate Right and Transpose.

What are the parameters required by a Crosstable Wizard to create a cross table?

There are three fields required to create a cross table. Qualifier field, Attribute Field and Data Field.

What does Partial Reload do?

It Executes the current load script, including all script commands, such as Drop Table and reloads data to the active QlikView document. However, only those tables whose load and select statements are preceded by the Replace or Add prefix are reloaded.

How can we see the table structures of data loaded to QlikView’s memory?

By using the Table Viewer Option under file menu we can see the Tables and their relationships.

What is the use of - Export Sheet layout?

When we want to preserve the layout of a sheet to be used again, we export the sheet layout which creates a XML file without any data.

What is Webview Mode?

The WebView mode uses the internal web browser in QlikView to display the document layout as an AJAX page.

What is a selection indicator in QlikView Document?

A selection indicator is used to indicate the type of association between the data present in different sheet objects. A green dot indicates selected values, blue dot indicates locked values and red dot indicates de-selected values in AND mode.

What does *bi* in text search mean?

It searches for any string that contains bi.

What is Fuzzy search in QlikView?

Fuzzy search finds all the values according to their degree of resemblance to the search string. Which means, even if the spelling does not match character by character, those results will also be shown.

What is a Bookmark in QlikView?

A bookmark in QlikView captures the selections in all states defined in a QlikView document. It can be saved and accessed later.

What is a user bookmark and a shared server bookmark?

The User bookmark is saved in the user computer while the shared server bookmark is saved in the server and accessible to all the allowed users.

What are the different ways in which the QlikView Alerts can be triggered?

The alerts can be triggered in three ways. (a) Automatically when there is a change in data (b) Manually from a internal macro (c) External program running QlikView API.

What are the two ways to insert Load statements into script editor?

(a) Form File (b) Inline

When do we need to use the option “Force 32 Bit”?

When connecting to a database using ODBC, if the data source only provides 32-bit driver we use this option.

What is a hidden script in QlikView?

A Hidden script is a part of the script that executes before the execution of normal script and it is protected by a password.

What is Information density in QlikView table Viewer?

It is a ratio between the numbers of records with not null values to the total number of records.

What is Subset Ratio?

It is ratio between numbers of distinct values found in the table as compared to total number of distinct values in the field whose subset ratio is required.

What are the default column names in Inline data load?

The default field names when inline data is inserted is – F1,F2,F3 etc. This can be edited.

What is the difference between QVX and QVD files?

The QVD file is a proprietary and optimized for minimum transformations inside QlikView but the QVX file has a open file format which shows both the table structure and the table data in it.

What is Garbage option in the Data Transform wizard?

The Garbage option is used to mark and delete the data that is not required or that is jumbled and not useful.

What feature does the Fill Tab in data transform wizard provide?

The fill feature is used to fill in empty cells with values from adjacent cells.

How can we split the data in a table vertically or horizontally?

The data in a table can be split by using the unwrap transformation.

What is Context cell Expansion in QlikView?

Context cell expansion is used to expand the contents of one cell into several cells in the table.

What is a binary statement in QlikView?

The binary statement is used load the access and data parts of a QlikView document. It does not load the layout information of the document.

Can we store a sound file in a QlikView document?

Yes we can. We can store an external file (audio/video etc.) using Bundle prefix in the QlikView document.

Can we concatenate two tables with different number of fields in QlikView?

Yes. Using concatenate function.

How can we drop some fields from the memory during script execution?

We can use the statement Drop field A;

What is the use of the function IntervalMatch?

The IntervalMatch prefix to a Load or Select (SQL) statement is used for linking discrete numeric values to one or more numeric intervals.

What is a Mapping Table?

The mapping table is a temporary table to provide a mapping of values forms one column in first table to another column in the second table. It has only two columns and it is dropped after script execution.

Review Date
Reviewed Item
Excellent!! Qlikview Interview Questions and Answers, Keep Updating More.
Author Rating