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.
If you would like to become a Qlik Sense Certified professional, then visit Mindmajix - A Global online training platform: "Qlik Sense Certification Training Course". This course will help you to achieve excellence in this domain.
Best QlikView Interview Questions and Answers
Q1. In QlikView, what are the objects having only expression and no dimension?
Ans Gauge chart and list box are the objects having only expression and no dimension.
Q2. Explain join and its types
Ans 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.
Ans Join merges two tables to create one table whereas Keep implements Join logic on two tables but maintains 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?
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.
Q6. What are CAL and its types?
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-
- Named CAL
- Document CAl
- Session CAL
- Usage CAL
Q7. How can you bring data into QV and handle early arriving facts?
Ans By using ODBC, OLEDB or SAP connectors as a data connection, we can load data using the Select statement.
Q8. What is the use of Comparative Analysis in the Qlikview Developer Platform?
Ans 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?
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.
Q10. What is Incremental load and Resident load?
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.
Q11. What are delimited files and why are they called CSV files?
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.
Q12. Is it possible to load web files into QlikView? If so, how?
Ans 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?
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.
Q14. What are Sheets in QlikView?
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.
Q15. In how many ways can the Script Editor be invoked?
Ans Script Editor can be invoked in two ways- either by the shortcut keys Ctrl+E or by the icon for Edit Script.
Q16. What is a Dashboard?
Ans 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?
Ans 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?
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.
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..!
Ans 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?
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.
Q24. What is a circular reference, and how to avoid it?
Ans 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?
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.
Q26. What are the types of authorization in QlikView?
Ans 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?
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.
Q28. What are the new features in QV 11?
Ans 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?
Ans 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?
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 Article:- Rename Field And Qualify In Qlikview ]
Q31. What P() and E() in the Set analysis?
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.
Q32. What is the difference between Pick and Match?
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.
Q33. What is the difference between RDBMS and Associative Data Model?
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.
Q34. Which tool is provided by QV to get a snapshot view of your table?
Ans 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?
Ans OLEDB, ODBC, and SAP connectors.
Q36. What for macros are used in your application?
Ans 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()?
Ans 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?
Ans By using Store command
By using buffer before load/select
via UI-[chart export]
Q40. What is the use of the Interval match function()?
Ans It is used to generate data buckets of different sizes.
Top QlikView Server Admin Interview Questions
Q41. What are the tasks and triggers in QMC (QlikView Management Console)?
Ans Tasks are generated to reload data, whereas triggers are created to schedule and run tasks at a certain time.
Q42. What is the QlikView server and Publisher?
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.
43. What is the function of different tabs on the QlikView Management console?
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.
Q44. What are CAL and its types in QlikView?
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
Q45. Name some databases that QlikView can connect to.
Ans Oracle, SQL Server, MySQL, Progress, DB2, MS Access, Informix, etc.
Q46. What Are The Main Features Of Qlikview?
Ans 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
Q47. What kind of Charts do we use in Qlikview Admin?
Ans We generally use a combo chart, scatter chart, bar chart, line chart, grid chart, etc.
Q48. How are the subset ratios and information density different from each other?
Ans 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.
Q49. What is Document-level Auditing in QlikView 11?
Ans Document-level auditing helps administrators to effectively audit the user interactions and improve risk management and compliance.
Q50. 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)
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