Top Answers to QlikView Interview Questions
1. Compare QlikView with Tableau.
|Performance||Uses a cubing technique that gives out results slower than QlikView||Faster than Tableau as it effortlessly combines all sizes of datasets|
|Interface||Comes up with a simple drag-and-drop interface that is easy, clean, and interactive||Has too many tools that are rarely used but certainly provide numerous ways for showcasing data|
|Suitable for||Provides dashboarding and rapid visualization||Offers departmental and enterprise-wide BI solutions|
|Product range||Has diverse products for varied uses||Has a single product for the entire BI solutions|
|Geographical maps||Building map visualization is easy with its in-built extension||Building map visualization takes longer since it needs scripting and an external extension for this|
|Tables||Weaker for tables||Very good for tables|
|Speed||Depends on RAM and the source database||Depends on RAM|
|Graphical inputs and changes||With easy drag and drop, graphical inputs are easy||For graphical changes, we will have to write the logic for it|
Watch this extensive video on QlikView and Qlik Sense Tutorial:
2. What chart types do we use in QlikView Admin?
In QlikView Admin, we generally use bar charts, line charts, combo charts, scatter charts, grid charts, etc.
3. Explain Set Analysis in QlikView.
Mostly used in aggregated functions like sum (year), avg, max, min, etc., set analysis is used to define a set (or a group) of data values.
4. Define Trellis chart.
In the trellis chart, we can create an array of charts based on the first dimension. It is basically a grid of small charts or a repetition of charts. Bitmap charts can also be made up of the trellis display.
5. Explain Mini chart. What do you mean by sub-reports and how can you create them?
In QlikView, with the help of a mini chart, we can set the type of modes, instead of values, in the table mode. We can also set colors for the chart.
Read this QlikView Tutorial to learn more about QlikView now!
6. What is Pivot table?
A pivot table is better at the time of grouping. We can also show a pivot table like a cross table, which is a beneficial feature. However, there is a disadvantage with pivot tables, i.e., if we have to sort a pivot table, then we have to sort it first according to the first dimension, then to the next.
7. Which graph can you use for 2 years' difference sale?
A bar graph can be used for this purpose.
8. What is Straight table?
A straight table is much better at the time of sorting when compared to the pivot table as we can sort the former according to any column as per our choice. However, it is not good for the grouping purpose.
9. How many dimensions can you use in a Bar chart?
In a bar chart, we can use only two dimensions.
10. Which QlikView object has only expression and no dimension?
Gauge chart and list box have only expression and no dimension.
11. How can you use Macros in your application?
We can use macros for various purposes, such as reloading the application and creating an object.
12. What do you understand by layers in QlikView?
Layers are basically set on sheet object properties in the layout tab, where there are options such as Bottom, Top, and Normal, respective to the numbers −1, 0, and 1.
Learn How QlikView is used as a BI tool and about its strengths, from this informative blog!
13. What are Dimensions?
Dimensions allow data examination from various perspectives.
14. Explain Normalized data.
- Normalized data: By saying normalized data, we mean the well-structured form of data, which doesn’t have any repetition or redundancy. It is a kind of relational data mainly used in OLTP-like stuff.
- Denormalized data: Along with normalized data, we have denormalized data as well. It is a whole bunch of data without any relationship among themselves, with the possibility of redundancy. It’s mainly used in OLAP-like stuff.
15. What is Star Schema?
Star schema is the simplest form of a dimensional model, in which data is pre-arranged into facts and dimensions.
16. What is Snowflake Schema?
A snowflake schema is a different form of the star schema. A snowflake schema is used to improve the presentation of particular queries.
17. Explain IntervalMatch.
IntervalMatch prefixes with the load statement that is used for connecting different numeric values to one or more numeric intervals.
18. Explain the IntervalMatch() function.
The IntervalMatch() function is used to generate data buckets of different sizes.
19. What is a Container?
A container object is used to keep multiple charts. We can use a container object to keep many charts in the same box.
20. What do you understand by the extended IntervalMatch() function?
The extended IntervalMatch() function is used for Slowly Changing Dimensions.
Are you interested in learning QlikView? Well, we have the top QlikView Training Course to give you a head start in your career!
21. What are the new features in QV 11?
Container object, granular chart dimension control, actions like clear filed, metadata, etc. are some of the new features in QV 11.
22. Explain Join and its types.
Join is used to convert the given data, and whenever we use joins for converting data it is known as data merging.
It has many types:
a. Left join
b. Right join
c. Inner join, etc.
23. What is Left Join?
Left join specifies that the join between two tables should be left join; it uses before the word ‘join’. The resulting table only contains the combination among two tables with the full dataset from the first table. When we have more than one common field between two or more tables, then we have synthetic keys.
24. 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 contains the combination among two tables with the full dataset from the second table.
25. Explain Inner Join.
Inner join specifies that the join between the two tables should be inner join. The resulting table should contain the full dataset from both tables.
26. What are Modifiers?
Modifiers deal with the Fields name.
The above code returns the sales for the current selection, but the selection in ‘Region’ is removed.
Go through this insightful blog to learn Why QlikView is such a great Business Intelligence tool?!
27. Explain Identifier's syntax.
- 0: Represents an empty set
- 1: Represents full sets of records
- $: Represents the record of the current selection
- $1: Represents the previous selection
- $_1: Represents the next selection
- Bookmark01: Represents the Bookmark name
28. Explain the 3-tier architecture of QlikView Application.
- Tier I: Raw data is loaded, and QVD is created
- Tier II: QVD is converted in business login and the requirement of business and data model is created.
- Tier III: Reading all QVD from Tier II, a single QVW is made.
29. How does QlikView store data internally?
QlikView stores data in QVD as QVD has data compression capability. QlikView has better performance than other BI tools because of its memory analytics approach.
30. Explain the restrictions of Binary Load for a QlikView Developer.
Binary Load can be used only for one application, i.e., we can only read data from one QVW application. Moreover, set scripts is also a restriction.
31. For a QlikView Administrator, differentiate between Subset Ratio and Information Density.
- Subset Ratio: It is used for easily spotting problems in the key field association. It is only relevant for key fields as they are present in multiple tables and do not share the same value.
- Information Density: It is the field that contains the percentage of rows with non-null values.
Interested in learning QlikView? Grab our online QlikView Administrator Training Course!
32. What is the use of Optimized Load?
Optimized load is much faster and preferable especially for large sets of data. It is possible if no transformation is made at the time of load and no filtering is done.
33. Differentiate between Keep and Join.
Keep and Join do the same functions, but keep creates two tables whereas join merges two tables to create one table. Keep is used before the load or select statement.
34. Define Synthetic Key.
A synthetic key is the key used when two or more tables consist of more than one common column among them.
35. 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.
36. Differentiate between the Set and Let options in QlikView.
- Set: It assigns a variable to a value without assessing the expression.
- Let: It assigns a variable to a value after assessing the expression.
37. Define QlikView Resident Load.
Resident load is a part of loading data in the QlikView application. It is used for loading the data in tables, which is already loaded in the Qlikview application.
38. How can you optimize a QV Application?
A QV application can be optimized by creating QVDs for data. When the complete QVW application is changed into a QVD, then this QVD will be stored in the RAM.
39. What is Mapping Load?
Mapping load is used to create the mapping table that can be used for replacing field values and field names.
40. Define Apply Map.
Apply map is used to add fields to tables with the help of other tables. It can be used as a join.
Give your career a big boost by taking up our QlikView Training now!
41. What is Concatenation?
Concatenation means a sequence of interconnected things, i.e., any columns or rows that are related to each other can be connected through concatenation.
42. Define NoConcatenation.
NoConcatenation prefix is used to force two identical tables as two separate internal tables.
43. Define the Connect statement.
The connect statement is used to establish a connection to the database with the help of an ODBC or an OLEDB interface.
44. What do you understand by Fact Constellation Schema?
Fact Constellation schema is a logical database structure of a data warehouse. It is designed with the help of a denormalized fact.
45. What do you mean by RDBMS?
RDBMS stands for ‘Relational Database Management System.’ It arranges data into respective columns and rows.
Have more queries? Clear all your doubts by sharing them on our BI Community and get them clarified within a day!
46. What do you understand by the term 'CAL' in QlikView Server?
Every client needs a CAL to get connected with Qlikview Server. CALS are taken up with QlikView Server and tied up with the server serial number.
47. Differentiate between QlikView Server and QlikView Publisher.
- QlikView Server is a program that is installed on a computer with various CALS allowing users to access the QV files on the server.
- QlikView Publisher is a program that has centralized control on our QV files and manages how and when they are loaded and distributed.
48. What do you understand by the Snapshot View of a table?
By this option, we can see a number of tables and related associations.
49. How can you bring data into QV?
We can use ODBC, OLEDB, or SAP connectors as a kind of data connection.
50. How can you handle Early Arriving Facts?
We can load data from ODBC, OLEDB, or SAP connectors with the help of the select statement, and we can load files like Excel, Word, etc. by using the table syntax.
51. What type of data do we use generally?
We use flat files, Excel files, QVDs, etc. as data.
52. Elucidate QlikView.
QlikView is the Business Intelligence tool used by the University of St Andrews. With QlikView, data from different university systems are 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 should be easy to learn and remember how to use a dashboard.
- To use QlikView, users need not have any technical expertise in information systems, but a willingness to learn would be good to have.
53. What are the benefits of using QlikView?
As the name suggests, QlikView is a combination of ‘quick’ and ‘click,’ and its features make it intuitive and easy to use. Users can visualize data, search in multiple datasets, create ad-hoc reports, and view patterns and trends in data that may not be visible in other reports.
- Flexible: Dashboards are web-based and accessible from desktop computers and mobile devices.
- Interactive: Users are able to easily drill down and select particular data from charts or tables.
- Usable: Users can see large amounts of data effectively and efficiently.
- Scalable: QlikView is useful for multiple business processes at analytical, operational, and strategic levels.
54. How is QlikView 11 different from QlikView 10?
QlikView 11 brings new levels of capabilities and manageability to the QlikView Business Discovery platform. In this release, it has focused its 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
Master QlikView with the latest version of Intellipaat’s QlikView Certification Training!
55. What is QlikView Comparative Analysis in the QlikView Developer platform?
Business users can quickly gain new insights when analyzing their information in QlikView, with its 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.
56. 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 10 SR3 or later versions
- A native browser, not a downloaded one
Currently, HTML5 web apps support only Apple and Android handhelds because BlackBerry devices are older that do not fully support HTML5 (and many of them are having non-touch screens). QlikView doesn’t have a web-based solution for them as of now.
57. For a 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 now audit QlikView usage not only at the system level (the entire QlikView Server) but down to the document level as well.
58. What are the key differences between QlikView and any other standard statistical software packages (SAS, SPSS, etc.)?
The key difference is in terms of the database used. While SAS is useful in the case of metadata and SPSS is good for analysis; QlikView offers quite a simple visualization that matches MS Excel filtering.
When comparing QlikView with the other two, it is the most user-friendly and the fastest 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.
59. What are QlikView Annotations?
With the new annotations collaboration object, QlikView users can engage in threaded discussions with the 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 that others can get back to the same place in the analysis when reviewing notes and comments. Also, QlikView captures the state of the object (current selections), as well as knows who has made each note and comment and when and how a decision was made.
60. What are the main features of QlikView?
QlikView offers the following features:
- Dynamic BI ecosystem
- Data visualization
- Interactivity with dynamic apps, dashboards, and analytics
- Search across the entire data
- Secure and real-time collaboration
61. What are the differences between QlikView Server editions?
- QlikView Server Enterprise Edition (EE) is available to those wishing 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
- QlikView Small Business Edition (SBE) is designed to be used in smaller deployments. It has the following limitations:
- Can only be used with Named and Document CALs
- Limited to 25 Name or User CALs
- Limited to 100 Document CALs
- No support for additional servers
- Only supports Windows Active Directory to handle security and access control
- QlikView Information Access Server (IAS) is designed to power public Internet sites. This edition:
- Includes the add-on, QlikView Real-time Server
- Is licensed for an uncapped number of users but limited to one QlikView document
- Must only be set to the anonymous mode, and authentication must be set as ‘Off’
- Requires that the QlikView Server be on the public Internet
- 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, etc.) can access the QlikView Server (all user interfaces must be built by the customer manually or with QlikView Workbench)
- QlikView Extranet Server (QES) is designed to extend QlikView functionalities to external users via an extranet. QES:
- Requires authentication, i.e., 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 three QlikView documents
- Supports session CALs and usage CALs only