If you're looking for QlikView Interview Questions and Answers for Experienced & Freshers, you are at right place. There are a lot of opportunities from many reputed companies in the world. According to research, QlikView has a market share of about 7.3%. So, You still have opportunities to move ahead in your career in QlikView. Mindmajix offers advanced QlikView Interview Questions 2019 that help you in cracking your interview & acquire your dream career as QlikView Developer.
Want to Become an Expert in QlikView? Then visit here to Learn QlikView Training Online.
Ans: Gauge chart and list box are the objects having only expression and no dimension.
Ans: Joins are used to merge data from different data sets into one. There are many types of joins-
Ans: Join merges two tables to create one table whereas Keep implements Join logic on two tables but maintain them separately.
Let: It assigns a variable to a value after assessing the expression.
Set: It assigns a variable to a value without assessing the expression.
[Related Post: Layout Tips For Developers – QlikView Scripting]
Ans: Fact Constellation Schema is a collection of multiple facts tables sharing common dimension tables. It is made up of several star schemas and hence also called galaxy schema.
Ans: CAL stands for Client Access License that offers different licenses depending on the user type. There are four types of CAL, and they are as follows-
Ans: By using ODBC, OLEDB or SAP connectors as a data connection, we can load data using Select statement.
Ans: By using the Comparative Analysis option, users can quickly gain new insights to analyze their information in Qlikview.
Ans: QVD files can be read in two modes- the standard and the optimized mode. The optimized load is a faster process and is preferable for large sets of data.
Ans: Qlikview Incremental load is used for loading new or changed records from the database, whereas resident load is a part of loading data which already present in the Qlikview application.
Ans: Delimited files are text files in which data fields and data values are separated by commas, semicolons and tabs, and that is why they are also called Comma Separated Values files. These files are saved with .csv extension.
Ans: Yes, it is possible to load web files into QlikView. It is done through the Script Editor.
Ans: Inline data is created on the spot and to load inline data in QlikView we need to open the Script Editor and then select the Insert option. After that, select Load Statement followed by Load from Inline.
Ans: A Sheet divides a QlikView document into multiple sections. Every document will have at least one sheet in it, if needed, we can add more from the Sheet Properties option.
Ans: Script Editor can be invoked in two ways- either by the shortcut keys Ctrl+E or by the icon for Edit Script.
[Related Post: Qlikview Synthetic Keys ]
Ans: A dashboard is a QlikView document which displays values from many fields simultaneously and makes the analysis process easier.
Ans: A buffer load is used to create a file using a buffer prefix in Qlikview's memory for future use.
Ans: Bar chart, Mekko Chart, Grid chart, Funnel chart, Line chart, Gauge chart, Combo Chart, Scatter Chart, Radar chart, Block chart, Straight table chart, Pie chart, and Pivot table chart.
Ans: The synthetic key is created to avoid confusion when two rows of the table are the same. In QlikView, automatically, this scenario is detected, and a synthetic key is created to make the process faster.
Ans: Auto-Generated function automatically generates the numbers between the given range.
Ans: Total three fields are required to create a cross table, and they are as follows: Attribute field, data field, and qualifier field.
Ans: The main difference between the entity-relationship model and dimensional model is-
In the ER model, a table can have foreign keys in multiple tables that lead to circular references. In a dimensional model, a fact table contains all necessary measures surrounded by dimensional tables.
Ans: In QlikView, tables get automatically connected to each other based on some key reference. This process leads to the formation of unwanted structures called a circular reference. It is a condition when there exist two or more association paths among three or more tables. This condition can be corrected by following ways-
Ans: Cyclic groups contain a set of dimensions that can be switched among users, whereas Drill down Groups contain a hierarchical list of dimensions used by users to drill down to access detailed levels of the data.
Ans: Authorization is nothing but permitting the users to access the resources. In QlikView, authorizations are implemented at multiple levels such as-
Ans: Interval match is one of the functions that are useful for the tables containing numeric values because it is used to match a numeric value from one table to another table.
Ans: New features of QV are as follows-
QVW- It is a QlikView file saved in binary format with default expression QVW containing tables, charts script etc.
QVD: It is a binary CSV file that contains one data table, no layout and no security.
Ans: QV Server is a program installed in a physical server with a number of CAL’s to authorize users to access QV files on the server. QV Publisher is a program that gives centralized control of all QV files and how to schedule them.
[Related Post: Rename Field And Qualify In Qlikview]
Ans: In QlikView Set Analysis, a P() function is used to return all possible values while an E() function is used for returning a set of all excluded values.
Ans: The Match() function checks whether the value of a string on expression is matching with data value present in a column. The Pick() function is used to return the nth expression along with string in the list.
Ans: RDBMS: stands for Relational Database Management System, and it stores data into rows and columns of tables and data is retrieved through SQL queries. An associative database model is comprised of two tables: one for items and one for links.
Ans: Table Viewer is the tool provided by QV that is used to get a snapshot of tables.
Ans: OLEDB, ODBC, and SAP connectors.
Ans: We can use macros for the following things-
Ans: It is used for slowly changing dimensions.
1. To increase load speed
2. Incremental Load
3. Ease of Maintenance
4. Consolidating data
5. Separation of Roles
6. Decreasing load on database servers
Ans: By using Store command
By using buffer before load/select
via UI-[chart export]
Ans: It is used to generate data buckets of different sizes.
Ans: Tasks are generated to reload data, whereas triggers are created to schedule and run tasks at a certain time.
Ans: QlikView Server hosts documents, users and objects whereas QlikView Publisher is a component of QVS which is responsible for data reduction and distribution, accessing and managing content. Users need to get a separate license for Publisher.
Ans: There are three tabs present on the QMC - Status, Documents, and Users. There are used for-
Status- It shows the list of tasks which are already executed and which are currently running on the server. By clicking on this tab, you can check which tasks are successfully completed, which failed, and which are running.
Documents- This tab contains sub-tabs - source and user document. The source documents contain dashboards created by developers, whereas user documents contain published dashboards.
Users- It contains data regarding the QlikView server environment and several services and to configure users, and clients access the license system.
Ans: CAL stands for Clients Access License which is a must to connect to the QlikView Server. There are different types of CAL present QlikView, and they are as follows-
Named User CAL- It is user-specific or machine-specific
Session CAL- Allows different users to control and access different documents
Usage CAL- It allows users to initiate a session
Document CAL- It permits to access a specific document
Ans: Oracle, SQL Server, MySQL, Progress, DB2, MS Access, Informix etc.
Ans: QlikView features are as follows-
Ans: We generally use a combo chart, scatter chart, bar chart, line chart, grid chart, etc.
Ans: Information density is defined as the ratio of null values to the total number of records present in the tables whereas subset ratio is the ratio of number of distinct values of a field in a table to the distinct values of the same field in all tables.
Ans: Document-level auditing helps administrators to effectively audit the user interactions and improve risk management and compliance.
Explore QlikView Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
These were some of the most important interview questions on QlikView for both freshers as well as experienced candidates. I hope this article has helped you in preparing for your interview.
If you have any doubts or query, do not forget to drop the question in the comment box below.
Check out other popular BI Tool Interview Questions
Free Demo for Corporate & Online Trainings.