If you're looking for QlikView Interview Questions and Answers for Experienced & Freshers, you are at the 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 2021 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.
QlikView Interview Questions and Answers
Q1. In QlikView, what are the objects having only expression and no dimension?
Gauge chart and list box are the objects having only expression and no dimension.
Q2. Explain join and its types
Joins are used to merge data from different data sets into one. There are many types of joins-
- Left join
- Right join
- Inner Join
- Outer join
Q3. Differentiate between Keep and Join.
Join merges two tables to create one table whereas Keep implements Join logic on two tables but maintain them separately.
Q4. What is the difference between the Let and Set options in QlikView?
Let: It assigns a variable to a value after assessing the expression.
Set: It assigns a variable to a value without assessing the expression.
Q5. What is Fact Constellation Schema?
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.
Q6. What are CAL and its types?
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-
- Named CAL
- Document CAl
- Session CAL
- Usage CAL
Q7. How can you bring data into QV and handle early arriving facts?
By using ODBC, OLEDB or SAP connectors as a data connection, we can load data using Select statement.
Q8. What is the use of Comparative Analysis in the Qlikview Developer Platform?
By using the Comparative Analysis option, users can quickly gain new insights to analyze their information in Qlikview.
Q9. In Qlikview, what is the use of an optimized load?
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.
Q10. What is Incremental load and Resident load?
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.
Q11. What are delimited files and why are they called CSV files?
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.
Q12. Is it possible to load web files into QlikView? If so, how?
Yes, it is possible to load web files into QlikView. It is done through the Script Editor.
Q13. What is Inline data? How can we load Inline into QlikView?
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.
Q14. What are Sheets in QlikView?
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.
Q15. In how many ways can the Script Editor be invoked?
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 ]
Q16. What is a Dashboard?
A dashboard is a QlikView document which displays values from many fields simultaneously and makes the analysis process easier.
Q17. What is buffer load, and why is it significant?
A buffer load is used to create a file using a buffer prefix in Qlikview's memory for future use.
Q18. How many types of charts are used in QlikView?
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.
Q19. What is a synthetic key, and what is its importance?
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.
Q20. What does the Auto-Generated function do in QlikView?
Auto-Generated function automatically generates the numbers between the given range.
Q21. What are the parameters needed by a crosstable Wizard to form a cross table?
Subscribe to our youtube channel to get new updates..!
A total of three fields are required to create a cross table, and they are as follows: Attribute field, data field, and qualifier field.
Q22. What are the advantages and disadvantages of QlikView?
- Data sharing
- Data interpretation and analysis
- Self-service tool
- Low Maintenance
- Data security
- Direct and indirect search
- Inefficient real-time data analysis
- Less RAM limit
Q23. What is the difference between dimensional and relational modeling?
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.
Q24. What is a circular reference, and how to avoid it?
In QlikView, tables get automatically connected to each other based on some key references. 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-
- Renaming data fields
- Creating a link table
- Concatenation of two tables together
Q25. What is the difference between the drill-down group (hierarchical groups) and the cyclic group?
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.
Q26. What are the types of authorization in QlikView?
Authorization is nothing but permitting the users to access the resources. In QlikView, authorizations are implemented at multiple levels such as-
- Data level
- Sheet Level
- Chart level
- Column level
Q27. What is interval match?
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.
Q28. What are the new features in QV 11?
New features of QV are as follows-
- Container Object-Grid Style
- Conditional enabling of dimensions and expressions
- Granular Chart
- Comparative analysis
Q29. Difference between QVD and QVW?
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.
Q30. What is the difference between QV Publisher and QV Server?
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]
Q31. What P() and E() in the Set analysis?
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.
Q32. What is the difference between Pick and Match?
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.
Q33. What is the difference between RDBMS and Associative Data Model?
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.
Q34. Which tool is provided by QV to get a snapshot view of your table?
Table Viewer is the tool provided by QV that is used to get a snapshot of tables.
Q35. What type of data connections are used in QlikView?
OLEDB, ODBC, and SAP connectors.
Q36. What for macros are used in your application?
We can use macros for the following things-
- To reload the application
- To create objects.
Q37. What is the use of extended Interval Match function()?
It is used for slowly changing dimensions.
Q38. What are the purpose and Uses of QVD files?
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
Q39. What are the types of QVD Creation?
By using Store command
By using buffer before load/select
via UI-[chart export]
Q40. What is the use of the Interval match function()?
It is used to generate data buckets of different sizes.
Top Interview Question and Answers for QlikView Server Admin
41. What are the tasks and triggers in QMC (QlikView Management Console)?
Tasks are generated to reload data, whereas triggers are created to schedule and run tasks at a certain time.
42. What is the QlikView server and Publisher?
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.
43. What is the function of different tabs on the QlikView Management console?
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.
44. What are CAL and its types in QlikView?
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
45. Name some databases that QlikView can connect to.
Oracle, SQL Server, MySQL, Progress, DB2, MS Access, Informix, etc.
46. What Are The Main Features Of Qlikview?
QlikView features are as follows-
- Data visualization
- Dynamic BI Ecosystem
- Searching across all data
- Secure, real-time collaboration
- Interacting with dynamic apps, dashboards and analytics
47. What kind of Charts do we use in Qlikview Admin?
We generally use a combo chart, scatter chart, bar chart, line chart, grid chart, etc.
48. How are the subset ratios and information density different from each other?
Information density is defined as the ratio of null values to the total number of records present in the tables whereas the subset ratio is the ratio of a number of distinct values of a field in a table to the distinct values of the same field in all tables.
49. What is Document-level Auditing in QlikView 11?
Document-level auditing helps administrators to effectively audit the user interactions and improve risk management and compliance.
50. What are the different services of the QlikView Server Environment?
- QMS (QlikView Management System)
- QVS (QlikView Server)
- QVWS (QlikView WebServer)
- QDS (QlikView Distribution Services)
- DSC (Directory Service Connector)
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 queries, do not forget to drop the question in the comment box below.
Check out other popular BI Tool Interview Questions