Top 70 Qlikview Interview Questions and Answers in 2021

In simple terms, Qlikview can be defined as a business intelligence tool that is used to convert raw data into knowledge. The BI tool provides data visualization in an innovative and meaningful way. QlikView usually works on an in-memory Associative model.

Table of Contents

Is QlikView easy to learn?

QlikView is the fastest developing Business Intelligence and data visualization tool. It is easy to learn, very fast to deploy, and very intuitive to use for a customer. So, if you want to improve your data visualization practices, then Qlikview is the perfect tool for you to start with.

Are you planning to attend a QlikView Interview? If you are looking for QlikView Interview Questions and Answers then, you are on the right page. Please go through the most frequently asked QlikView  Interview Questions and Answers, which will be helpful to crack your interview.

Top QlikView Interview Questions and Answers

1. Give the syntax for creating a QVD file?

STORE<Name of the table>INTO<Path\FileName.qvd>.

2. Differentiate between QlikView with Tableau?

QlikView Interview Questions - with Tableau
QlikViewTableau
It is faster in this case. QlikView can combine all sizes of datasets.In terms of performance, Tableau makes use of the cubing technique, which gives the results slower than QlikView.
Strong visualizations with BI reporting.Real-time visualization.
In the case of QlikView, gauge charts are available and also have 3D graphs to showcase the data.It will not support gauge charts and 3D graphs.
Speed depends on RAM.Here, the speed depends on RAM and the source database.

3. List the options available in the menu bar of QlikView?

On the menu bar of QlikView, there are various menus available so that the user can adjust the properties, add new objects, etc. The options available in the menu bar are listed below:

  1. File
  2. Edit
  3. View
  4. Selections
  5. Layout
  6. Settings
  7. Bookmarks
  8. Reports
  9. Tools
  10. Object
  11. Window
  12. Hel

4. Can you name the chart types that can be used in QlikView Admin?

There are 13 Chart types that can be used in QlikView Admin and are listed below:

  1. Bar chart
  2. Line Chart
  3. Combo Chart
  4. Radar Chart
  5. Gauge Chart
  6. Mekko Chart
  7. Pivot Table
  8. Scatter Chart
  9. Grid Chart
  10. Pie Chart
  11. Funnel Chart
  12. Block Chart
  13. Straight Table
See also  Top 60 Data Warehouse Interview Questions and Answers in 2021

5. Can you list the operations that can be performed using the Tools menu given in the Menu bar?

  1. In the Tools menu, we use the Edit Menu to edit the tools.
  2. To make different kinds of charts using wizards such as  Quick Chart Wizard, Statistics Chart Wizard, Time Chart Wizard, and Box Plot Wizard. 
  3. Two other tasks are managed through the menu, which are Alerts and Themes making.

QlikView Interview Questions and Answers

6. Define the Trellis chart?

Trellis is a grid-like structure. In the same way, in QlikView, a chart can be created in a way that it displays in a grid, and each section or block of the grid defines a single field value from a field.

7. Define Set Analysis in QlikView?

Set Analysis in QlikView predefines the SET OF DATA that the charts or tables use. So, using a Set Expression, you can tell the object, i.e., chart or table, to display values that are corresponding to various sets of data. 

For example, a pre-defined time period, product lines, geographic region, etc

8. Define the term Delimited files? Why are they known as CSV files?

A delimited text file can be defined as a text file that is used to store data, where each line represents a single book, company, or other things, and each line has fields that are separated by the delimiter. These files are also called CSV files because CSV stands for Comma Separated Values. The CSV files are usually saved in .csv extension.

9. Define a Pivot table?

The pivot tables in QlikView enable us to expand and collapse the dimensions on the axes by a single field value. This, in turn, allows us to drill down into details for one or multiple field values while keeping the totals for others.

10. Define the Mini chart?

A Mini Chart in Qlikview is a way to represent the bar chart and trend chart in the cell of metrics. It is useful because in one column, the chart shows the current or present value, and in the other cell, it shows the historical trends of that value. 

QlikView Interview Questions and Answers

11.  Define XML files? How will you load XML files into QlikView?

An XML(Extensible markup language file) is used to structure the data for storage and transport. In an XML file, we have both tags and text. The tags are used to provide the structure to the data. The text in the file that will be stored is surrounded by the tags, which will adhere to specific syntax guidelines.

To load the XML files into Qlikview, We follow the steps:

  1. First, go to the Edit Script the click on the Insert option.
  2. Now, select the Load Statement and then select Load from File option
  3. Then, a dialog box will appear from where you can browse the data files and select them.

12. Can you name the QlikView objects that have only expression but no dimension?

The QlikView objects that have the only expression but no dimension are: 

  1. Gauge chart
  2. List box.

13. What is a Straight table in QlikView?

Straight Tables in QlikView are the most widely used sheet objects to display the data. They are very simple with features like column rearrangement, coloring, sorting and the background, etc.

14. List the various types of data load?

In QlikView, there are seven different types of load:

  1. Resident Load
  2. Load from files
  3. Incremental Load
  4. Inline Load
  5. Add Load
  6. Buffer Load
  7. Binary Load

15. What is the purpose of macros in the application?

Macros are used for purposes like recording applications and creating an object. We can run QlikView macro in variable, sheet, and document events. 

  1. In order to add a macro to an event, you can go to Settings>Document Properties, or
  2. You can go to Settings>Sheet Properties.
  3.  To add a macro to a document event, you need to go to the Triggers tab in the document properties window.

QlikView Interview Questions and Answers

16.  How many dimensions are used in a Bar chart?

We will be using only two dimensions in a Bar chart.

17. List the types of files you can load data from?

  1. Excel files(Xls)
  2. Dif files
  3. XML
  4. Kml files,
  5. CSV files,
  6. web files (html),
  7. Qvd 
  8. Qvx files.

18. How are layers set in QlikView?

Layers are usually set on sheet object properties that are present in the layout tab; There are options such as top, bottom, and normal, respective to the numbers 0, −1, and 1.

19. What are Dimensions and Measures?

 The fields with informative values such as  ID, category, line are called Dimensions. Dimensions are always descriptive text values. 

Measures: These are the fields upon which calculations are performed, such as Product cost and quantity.

20. How can we load inline data into QlikView?

Inline data can be defined as the data set that is defined as well as it loads in itself. Inline data is usually created on the spot, and it is not loaded from the external data file.

To load inline data 

Open the Inline data load option, open the script editor then, go to Insert->Load Statement ->Load Inline.

Inserting Data: On opening the screen by following the above steps, A spreadsheet-like document is opened where you can type values. You can also paste the values that are already available in the clipboard. Click Finish.

Load Script: The command to load the data is created in the background, which is seen in the script editor.

QlikView Interview Questions and Answers

21. Define IntervalMatch() function?

IntervalMatch of the QlikViewis a powerful function that is used to match distinct numeric values to the numeric intervals; it is used in analyzing how events actually happened vs. the planned events.

22. Explain Normalized data and De-Normalized data?

Normalization is a technique of reorganizing the data in a database so that it meets the basic requirements: i.e., there is no data redundancy, all the data is stored in only one place. Data dependencies are logical.

Denormalization can be defined as a strategy that is used on a previously normalized database to increase its performance. In terms of computing, denormalization is the technique trying to improve read performances of a database by losing some write performance, by adding the redundant copies of data, or by grouping the data.

23. Explain how to connect to a database from the script editor?

  1. Open the script editor in QlikView.
  2. Click on the connect option after choosing the ODBC in the database option. 
  3. A window appears that shows all the existing databases.
  4.  Select MYSQL userdsn (DSN)
  5. Click on the test connection.

24. What is a container?

A container can be defined as a QlikView object that holds various charts in the same box, as seen below. All the charts appear in the same window, but only one chart will appear as active at a specified time, is and navigation to various charts in the container can be done by using the bottom tab.

See also  Top 60 Business Analyst Interview Questions and Answers in 2021

25. What are Star Schema and Snowflake schema?

Star schema can be defined as the simplest form of a dimensional model, where the data is pre-arranged into dimensions and facts.

A snowflake schema is a different form that of the star schema. A snowflake schema improves the presentation of specific queries.

QlikView Interview Questions and Answers

26. List few databases that QlikView can connect to?

The QlikView can connect to most of the popular databases such as

  1. MySQL,
  2. SQL Server,
  3. Oracle
  4. Postgress et

27. Name the types of Joins?

Types of joints are:

  1. Left Join
  2. Right Join
  3. Inner Join.

28. List the new features in QV 11?

A few of the new features in QV 11 are:

  1. Container object
  2. Granular chart dimension control
  3. Actions like clear filed, metadata, etc. 

29. Define Resident Load?

When a table or file which has been already loaded and is residing in the QlikView’s memory and is called again, it is defined as Resident Load.

30. Can you explain the three tiers of the QlikView Application?

Three tiers of QlikView Application are defines as given below:

  1. Tier I: Here, the raw data is first loaded, and then the QlikView Data is created
  2. Tier II: Here, the QlikView data is transformed to a business login, and the needed data model is created.
  3. Tier III: Here, reading all QlikView data, which are there in Tier II, and one QlikView Data is made.

QlikView Interview Questions and Answers

31. Define Modifiers in QlikView?

Modifiers in QlikView are used to make changes or additions to a selection. Such modifications are written in a set expression. A modifier contains one or several field names, where each one is followed by one or more selections that are made in a field. Modifiers usually begin and end with angle brackets.

32. Define Incremental Load?

Incremental Load

An incremental load in QlikView happens when the fresh data is loaded from the source database, even though previously retrieved data is loaded from the local store. Stored data is typically in QlikView Data files or a QVW which is then used for a binary load.

33. How can we load Web files into QlikView?

QlikView will process the files from the web, which are in HTML format.

You have to select the Web files option from the Data from files section under the Data tab of the script editor. Then follow the steps:

  1. Give the URL as input.
  2. Select the table from the Web File.
  3. Select the columns of the table
  4. Load the script

34. Can you explain the Identifier’s syntax?

  1. 0: Represents the empty set
  2. 1: Represents a full set of records
  3. $: Represents record of the current selection
  4. $1: defines the previous selection
  5. $_1: Represents next selection
  6. Bookmark01: defines the Bookmark name

35. Define Preceding Load?

Preceding load in QlikView is a load type where we use the load statement, which will take the columns of another load statement that is present in the same script. The data is read by the first Load statement, which is usually at the bottom of the script editor window, and then it is used by the load statements above it.

QlikView Interview Questions and Answers

36. What is Binary Load?

Binary Load in Qlikview replicates the data model of the existing QlikView document into another QlikView document without accessing an original data source. Once the data model is replicated into another QlikView document, it can be further manipulated and integrated into a bigger data model.

37. How is the data in QlikView stored internally?

QlikView usually stores the data in a QVD as QVD has the data compression capability. QlikView has a better performance than other BI(Bussiness Intelligence) tools because of the memory analytics approach.

38. Define Buffer load and its significance?

We use the QlikView buffer load statement to transform the file into a QVD file or create and maintain a file like QVD in the QlikView’s memory for future use. These files are created by using a Buffer prefix and are typically stored in a user-defined location that is selected through User Preferences > Locations.

39. Define QVD file?

A QlikView Data(QVD) file is defined as a file that consists of a table of the data exported from the QlikView. Here, the file format is usually optimized for speed while reading the data from the QlikView script but is still very compact. Reading the data from the QVD file is usually 10-100 times faster than reading data from other data sources.

40. What restrictions do a Binary Load has on a QlikView Developer?

The Binary Load is used only for one application(we can only read data from one QVW application). 

QlikView Interview Questions and Answers

41. Explain the importance of QVD files in QlikView?

  1. QVD files are a gift to the QlikView as they are notably faster to load and process. 
  2. It is said that processing these kinds of files is 10 to 100 times faster than the usual files. 
  3. These files are capable of storing a large amount of data.

42. Define Kurtosis() and Skew() functions?

The Kurtosis() finds the kurtosis of a range of the data that is aggregated in the expression or field iterated over chart dimensions. An alternative set of records are defined by a set analysis expression. Kurtosis() measures the peak of the curve.

The Skew () function measures the symmetry in a distribution curve.

43. Differentiate between Subset Ratio and Information Density?

Subset Ratio: It is used for spotting problems easily in the key field association. It is only applicable for key fields as they are present in various tables and don’t share the same value.

Information Density: It is the percentage of non-null rows in a field. For example, afield country has a total of 10 Records, but three of the records are null, then

there are 7 non-null values hence their  information density = 70 %.

44. Explain how QVD files created?

The QVD files are usually created by using the STORE statement during the loading of the QlikView files. This statement usually creates a single qvd file that is stored in a specified location as a file, separate from the QVW file through which it is created.

See also  Top 50 ETL Interview Questions and Answers in 2021

45. How many types of Match() functions are there in QlikView?

There are two types of Match() functions in Qlikview they are:

  1. Match()
  2. Wildmatch()

QlikView Interview Questions and Answers

46. Can you differentiate between Keep and Join?

KeepJoin
In the keep, both the datasets are available in QlikView’s memory.In join, the load statements will produce only one data set from where you need to choose the columns.
Here, there is no concept of the outer keep.There is a concept of outer join.

47. Define Sheets in QlikView?

Sheet Objects are defined as the QlikView data elements which are embedded in the sheet. They usually display the data that is loaded into QlikView’s memory. Here, each of the sheet objects is linked to the data source and one or multiple columns. 

48. Differentiate between the multi-box and list box?

Multi-boxList box
The multi-box is a compressed table that shows the multiple table fields.Here, the list box shows all the values of single table fields in the form of the list.

49. Can you define Synthetic Key? 

A Synthetic Key is a QlikView’s solution where it creates an artificial key when there is any ambiguity about which key is to be used between the two tables. This situation usually arises when two tables have multiple fields in common.

50. List the sheet objects available in QlikView?

Some of the sheet objects are:

  1. List box
  2. Statistics box
  3. Multi-box
  4. Table box
  5. Chart
  6. Input box
  7. Current Selection box
  8. Button
  9. Text Object
  10. Line/Arrow Object
  11. Slider/Calendar Object
  12. Bookmark Object

QlikView Interview Questions and Answers

51. Explain the Architecture of Qlikview?

Architecture of Qlikview

The Qlik view architecture mainly comprises three main components. All these components are helpful in designing, developing, and implementing the QlikView application. They are:

  1. QlikView Server
  2. QlikView Publisher
  3. QlikView Desktop.

QlikView Desktop: It is a Windows-based development tool. Developers use this to create a QlikView data model and GUI layout for applications to use at the frontend.

QlikView Server (QVS): The applications that are created in the desktop version are usually hosted on the Qlik View Server so that the users can access them and use them anywhere. A QlikView server has to maintain the communication between client and end-users.

  1. QlikView Publisher: It is an optional mobile for QlikView server-side component. The component will allow you to fetch the data from data sources like Salesforce, standard data files, and it loads the data directly into QlikView files.
  2. QlikView Management Console: Itis a platform that manages all the other QlikView components. It is usually a web-based interface and a server-side application that is controlled by IT professionals.
  3. QlikView User Access: It enables the customers to access and manipulate the data files. The access points for the user are usually web browsers that can open using the desktop, laptops, mobile, etc.

52. Can you distinguish between the Set and Let options in QlikView?

SetLet
It is used to assign a variable to a value without evaluating the expression.It is used to assign a variable to a value after evaluating the expression.

53. Define QlikView Dashboard? 

The Qlikview Dashboard is usually a sheet or a document that consists of various kinds of sheet objects that contain the loaded data in the Qlikview script when you load. 

54. Can you list the different components of a dashboard?

The different components are:

  1.  Input Boxes
  2. Texts or list box Objects
  3. Selection Boxes
  4. Charts
  5. Notes and Comments.

55. How to optimize a QV Application?

We can optimize a QV application by creating QVDs for data. When a complete QVW application is changed into QVD, then this QVD will be then stored in a RAM.

QlikView Interview Questions and Answers

56. List some major categories into which QlikView’s functions are divided?

  1. Aggregation
  2. Date and Time
  3. Exponential and Logarithmic
  4. Financial
  5. General Numeric
  6. Logical Function
  7. Mapping Function
  8. Number Interpretation
  9. Range
  10. String
  11. Trigonometric and Hyperbolic

57. State the basic difference between SELECT and LOAD statements?

We can load the data into QlikView using the LOAD and SELECT statements.

SELECTLOAD
We use SELECT  to load data from databases.It is used to load data from files.
It loads the data from OLE DB or ODBC data sources.It loads the data from all files, i.e., from inline data,  autogenerated data, previously loaded data, etc.

58. Define Mapping load?

Mapping to load statements tells the Qlikview that a table is Mapped with other tables. A mapping table can have up to 2 columns(The lookup value and the mapping value). Mapping Tables are temporary tables since they are removed automatically from the data model at the end of the execution of the script.

59. Can you name some of the String functions?

In QlikView, the String Functions are applied to the text or strings values that are used in data load scripts.

A few of the commonly used String functions are listed below:

  1. ord(s)
  2. chr(n)
  3. len(s)
  4. capitalize(s)
  5. evaluate(s)
  6. left()
  7. right()

60. Explain the concatenation in QlikView?

The Concatenation feature in QlikView is mainly used to append the rows from one table to another table. It also happens even the tables have different numbers of columns. It is different from Join and ‘Keep’ command because it does not merge the matching rows from the two tables into one row.

QlikView Interview Questions and Answers

61. Explain the term Apply Map?

The ApplyMap script function is mainly used for mapping outputs of an expression to the previously loaded mapping table.

62. How to reload a script?

The script is reloaded after making changes by using the shortcut keys Ctrl+R or by the icon that is given on the toolbar for Reload script.

63. Define QlikView annotation?

The QlikView annotation helps the users to engage in threaded discussions with their content. If a user creates a note that is associated with the QlikView object, then other users will add comments on it.

64. List some date and time functions?

  1. Today()
  2. localtime()
  3. month()
  4. year()
  5. makedate()
  6. timezone()
  7. GMT()
  8. day()
  9. week()
  10. month()
  11. year()

65. List the different types of tables in QlikView?

  1.  Pivot table
  2. Straight table
  3. Crosstable
  4.  Mapping table, etc.

QlikView Interview Questions and Answers

66. List the four types of CAL?

  1. Usage CAL
  2. Named CAL
  3. Document CAL
  4. Session CAL

67. Can you list the types of authorization that are implemented at multiple levels in QlikView?

  1. Data level
  2. Column level
  3. Sheet Level
  4. Chart level
  5. Document-level

68. Name the different services of the QlikView Server Environment?

  1. QVS (QlikView Server)
  2. QVWS (QlikView WebServer)
  3. DSC (Directory Service Connector)
  4. QMS (QlikView Management System)
  5. QDS (QlikView Distribution Services)

69. Define Circular loops in QlikView?

A circular looping in QlikView is a concept that is created when the relationship between the two tables is established directly or through the third table.

70. List the features of Qlikview?

  1. Dynamic BI ecosystem.
  2. Data visualization.
  3. It Interacts with dynamic apps, dashboards, and analytics.
  4. It searches across all data.
  5. Secure, real-time collaboration
  6. API availability.
  7. Application integration.
  8. Business analysis

Good luck with your QlikView Interview, and we hope our QlikView Interview Questions and Answers were of some help to you. You can also check our Tableau Interview Questions and Answers and Power BI Interview, which might be of some help to you. 

Recommended Articles