You are right place, If you are looking for Qlikview interview questions and answers, get more confidence to crack interview by reading this questions and answers we will update more and more latest questions for you…
- What are the unique features of QlikView?
(a) Data Association is maintained automatically.
(b) The structure, knowledge and calculations of a report square measure all control within the memory (RAM) of the server.
(c) Knowledge is compressed to 100% of its original size.
(d) Visual relationship using colors.
- What is Incremental Load?
The idea of loading solely the new or modified records from the supply into the QlikView document is termed progressive Load.
- How you connect QlikView to Database?
QlikView can connect to data base using ODBC connection created for the database.
- What is Dashboard?
A dashboard could be a QlikView document that shows several matrices along and therefore the prices within the sheet objects will modification dynamically upon choice of bound value in one amongest the Sheet Objects.
- Why do we need a Master Calendar?
The Master calendar is required when we want to create some additional date values which are not already captured in the data that is being analyzed. For example finding the quarter to that a given date falls etc.
- What is Aggr Function?
AGGR statement perform produces a virtual table, with one expression and grouped by one or more dimensions. The results of this virtual table will then be employed by an additional outer aggregation function(s).
- What is a star schema?
A Star schema could be a knowledge model during which one reality table is connected to multiple dimension tables although foreign keys
- What is the difference between Join and Keep?
In case of keep both the datasets are available in QlikView's memory while in join the load statements produce only one data set from which you have to choose the columns. Also there is no concept of outer keep where as we have outer join available in case of joins.
- What is artificial key, is it good or bad to have?
QlikView creates an artificial key once 2 or additional column between tables square measure same. It doesn't impact {the knowledge the info the information} or performance however it indicates a flaw within the data model style.
- Difference between Join and Concatenate?
Join gives the resulting records from two tables as records containing columns form both tables. But Concatenate only appends the rows from one table with another.
- What are Circular loops in QlikView?
A circular loop is formed once the connection between 2 tables are often established each directly and thru another third table.
- What does Month Start function do?
Returns a price comparable to a timestamp with the primary time unit of the primary date of the month containing date.
- What does Auto generate Function do?
This function auto generates values between a given range of numbers.
- What is a pivot table in QlikView?
Pivot Tables square measure accustomed gift add of values across several dimensions out there within the knowledge. For example showing the full sales figure for each the months and quarters in a very years.
[ Related Article - Dashboard Starters and Pivots in Tableau? ]
- What square measure the vi chart varieties out there in QlikView?
Bar Chart, Pie Chart, Line Chart, Gauge Chart, Pivot table, Straight table.
- Can QlikView extract data from website? How?
Yes. In QlikView script editor we have the option to extract data form a web file by giving the URL as the input.
- What is the utilization of Promote/Demote choices in a very Table Box property?
It permits you to set up the columns within the Table box that is displayed within the Sheet.
- What square measure the 3 choices out there underneath the Rotate table practicality for knowledge transformation?
Rotate Left, Rotate Right and Transpose.
- What are the parameters required by a Crosstable Wizard to create a cross table?
There are three fields required to create a cross table. Qualifier field, Attribute Field and Data Field.
- What does Partial Reload do?
It Executes this load script, including all script commands, such as Drop Table and reloads data to the active QlikView document. However, solely those tables whose load and choose statements square measure preceded by the Replace or Add prefix square measure reloaded.
- How can we see the table structures of data loaded to QlikView’s memory?
By exploitation the Table Viewer possibility underneath file menu we will see the Tables and their relationships.
- What is the employment of - Export Sheet layout?
When we need to preserve the layout of a sheet to be used once more, we have a tendency to export the sheet layout that creates a XML file with none knowledge.
- What is Webview Mode?
The WebView mode uses the interior applications programme in QlikView to show the document layout as associate degree mythical being page.
- What is a selection indicator in QlikView Document?
A selection indicator is employed to point the sort of association between the information gift in several sheet objects. A green dot indicates selected values, blue dot indicates locked values and red dot indicates de-selected values in AND mode.
- What does *bi* in text search mean?
It searches for any string that contains bi.
- What is Fuzzy search in QlikView?
Fuzzy search finds all the values according to their degree of resemblance to the search string. Which means that, even if the spelling does not match character by character, those results will also be shown.
- What is a Bookmark in QlikView?
A marker in QlikView captures the picks altogether states outlined in a very QlikView document. It can be saved and accessed later.
- What is a user marker and a shared server bookmark?
The User marker is saved within the user pc whereas the shared server marker is saved within the server and accessible to any or all the allowed users.
- What square measure the various ways that within which the QlikView Alerts are often triggered?
The alerts can be triggered in three ways.
(a) mechanically once there's a amendment in knowledge
(b) Manually from a internal macro
(c) External program running QlikView API.
- What square measure the 2 ways that to insert Load statements into script editor?
(a) Form File
(b) Inline
- When will we ought to use the choice “Force thirty two Bit”?
When connecting to a database using ODBC, if the data source only provides 32-bit driver we use this option.
- What is a hidden script in QlikView?
A Hidden script could be a a part of the script that executes before the execution of traditional script and it's protected by a parole. - Script Expressions & Quotation Marks in Qlikview
- What is Information density in QlikView table Viewer? What is Subset Ratio?
It is magnitude relation between variety's of distinct values found within the table as compared to total number of distinct values within the field whose set magnitude relation is needed.
- What square measure the default column names in Inline knowledge load?
The default field names once inline knowledge is inserted is – F1,F2,F3 etc. This can be edited.
- What is the distinction between QVX and QVD files?
The QVD file could be a proprietary and optimized for minimum transformations within QlikView however the QVX file contains a open file format that shows each the table structure and also the table data in it.
- What is Garbage possibility within the knowledge rework wizard?
The Garbage possibility is employed to mark and delete the information that's not needed or that's topsy-turvy and not helpful.
- What feature will the Fill Tab in knowledge rework wizard provide?
The fill feature is employed to fill in empty cells with values from adjacent cells.
- How can we split the data in a table vertically or horizontally?
The data in a table can be split by using the unwrap transformation.
- What is Context cell Expansion in QlikView?
Context cell expansion is used to expand the contents of one cell into several cells in the table.
- What is a binary statement in QlikView?
The binary statement is employed load the access and knowledge components of a QlikView document. It doesn't load the layout info of the document.
- Can we have a tendency to store a sound enter a QlikView document?
Yes we can. We can store an external file (audio/video etc.) using Bundle prefix in the QlikView document.
- Can we concatenate two tables with different number of fields in QlikView?
Yes. Using concatenate function.
- What is the use of the function Interval Match?
The Interval Match prefix to a Load or choose (SQL) statement is employed for linking distinct numeric values to at least one or additional numeric intervals.
- What is a Mapping Table?
The mapping table could be a temporary table to supply a mapping of values forms one column in initial table to a different column within the second table. It has only two columns and it is dropped after script execution.
- What does No Concatenate do?
The No concatenate operate forces 2 tables with identical fields to be treated as 2 separate internal tables.
- What is the difference between NullAsValue and NullAsNull?
NullAsValue allows linking of data which are null but NullAsNull treats the null values as missing values and does not allow any linking between such values.
- How will we have a tendency to get the quantity of statements that have caused errors throughout a script execution?
Using of ScriptErrorCount system variable.
- What is the value of X in the following code?
set VAL=’$1*$2’;Let X = $(VAL(6,4,9));24