QlikView Interview Questions and Answers for Updates

21. How many types of charts can be created in QlikView?
Ans: There are total 13 types of charts in QlikView and their names are;

Bar chart, Line chart, Combo Chart, Scatter Chart, Mekko Chart, Gauge chart, Pie chart, Funnel chart, Radar chart, Block chart, Grid chart, Straight table chart and Pivot table chart.

22. Discuss one scenario where you can use Rank() function?
Ans: Let us suppose that a car company wants to know the performance of countries in sales. For this, they would want to rank the countries based on sales occurred in them. For this we will use Rank() function on the total of sales amount for each country. The expression would look something like this, Rank(sum(Sales_in_country)). This would rank the countries from highest to lowest based on total sales value for each. If Australia had sales of 10,00,000 it will rank 1st. Then if the USA had sales of 9,80,000 then it will rank 2nd and so on.

23. What is a Star Schema?
Ans: A star schema is a way of representing a data model which has a central fact table to which individual dimension tables link. It is a relational database model which shows a multi-dimensional database. It named as a star schema because the entire relationship diagram of the fact table and dimension table looks like a star.

24. What operations can you consider using the Tools menu given in the Menu bar?
Ans: In the Tools menu we can use the Edit Menu to edit the tools, make different kinds of charts using wizards like Quick Chart Wizard, Time Chart Wizard, Statistics Chart Wizard and Box Plot Wizard. Two other tasks can be improved through this menu which are Alerts and Themes making.

25. What do you mean by Buffer load? How is it Significant?
Ans: A buffer load statement is used to transform a file into QVD file or create and maintain a file as QVD in QlikView’s memory for future use. Such files are created using a Buffer prefix and is typically stored in the user defined location selected through User Preferences > Locations.

26. Mention the difference between a list box and a multi box?
Ans: A list box displays all the values of a single table field in the form of a list. It is used to make selections of data values convenient. Whereas, a multi-box is a compressed table showing only the fields on display. You need to click on the Add sign to view data values of each field. So, the main difference between the two is that in list box you can only get one field displayed but in a multi-box all the fields can display.

27. What Is Windows Installer?
Ans: The Windows installer is standard developed by Microsoft for software installation, modification, repair and removal. The installation package, also known as the msi, comprises of a database and the files to be installed

28. What is the difference between Keep, Join and Concatenate?
Ans: This is the general QlikView interview question asked in an interview. In case of keep both the datasets are available in QlikView’s memory while in the case of the join the load statements produce only one dataset from which you have to choose the columns. There is no concept of the outer keep whereas we have outer join available in case of joins. Join gives the result from two tables as records containing columns form both tables. But Concatenate only appends the rows from one table to another.

29. Define Trellis char?
Ans: In the trellis chart, we can create an array of charts based on the first dimension. It is generally a grid of small charts or a repetition of charts. Bitmap charts can also be made up of the trellis display.

30. Mention The Differences Between Pivot Tables And Straight Tables?
Ans: Pivot data is grouped. Partial sums can be shown in pivot tables, but not straight.

31. Can The Installation Overwrite Important System Files?
Ans: No, the overwriting of files is handled by the Windows installer service itself which uses the Windows File Protection rules.

32. Deacribe the Synthetic key and how to avoid it in QlikView?
Ans: In QlikView data structure, it is undesirable to have multiple common keys across multiple tables. Due to this QlikView may use the complex

keys Synthetic key to generate the connections in the data structure. Synthetic keys use a heavy resource and may slow down calculations, in extreme cases, degrade the performance of the applications. This key also makes a document difficult to understand and maintain. There are some scenarios where synthetic keys cannot be avoided (Example- Interval Match tables), but, in general, synthetic keys should always be removed, if it is possible to comment the fields in load scripts rename the fields using UNQUALIFY operator.

33. What do you know about associative nature of data in QlikView?
Ans: By associative nature of data, it is meant that all the fields and data field values are associated with each other (the ones loaded in the same document). For example, if there is a table on country wise sales, it is related to sales in QlikView document .Then when we select a country, say India, from a column in the table, data values related or linked to sales in India will get filtered by the system. All the other, unrelated/irrelevant information will be deactivated or sorted out.

34. Can we load Web files into QlikView? If yes, how?
Ans: Yes, we can load web files into QlikView. It is done through the Script Editor wherein the Data tab an option of ‘Web Files’ is given. select the option and will ask for the URL of the web file and the file can be loaded.

35. How can you handle Early Arriving Facts?
Ans: 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.

36. What the mobile device platforms does QlikView 11 support?
Ans: QlikView 11 delivers mobile are the functionality for Apple iOS and Android tablets and smartphones. QlikView supports Android tablets when the following given 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.

37.Name the types of files you can load data from?
Ans: In the Load from files type of load, data can be loaded using several different file types. These files are, Excel files(xls), Dif files, Xml, Kml files, CSV files, web files (html), Qvd and Qvx.

38.What are Sheets in QlikView?
Ans: Sheets divide a QlikView document into several sections. Every document will have at least one sheet and that is named ‘Main’, you can add more if you want and edit their properties from the Sheet Properties option.

39. What do you understand by Kurtosis() and Skew() functions?
Ans: Kurtosis() and Skew() are a type of statistical aggregate functions. Kurtosis() measures the peak of a frequency distribution curve. anyway, Skew() measures the symmetry in a statistical distribution curve.

40. What does the Unwrap function do?
Ans: The Unwrap function undo the operations performed by the Wrap function. The wrap function takes the bottom half of a table and puts it adjacent (on the right section) of the first half. Whereas, the unwrap function takes this right section of the table and puts it back below the upper section of the table.