QlikView - Interview Questions

(a)Data Association is maintained automatically. (b) The structure, data and calculations of a report are all held in the memory (RAM) of the server. (c) Data is compressed to 10% of its original size. (d) Visual relationship using colors.

The concept of loading only the new or changed records from the source into the QlikView document is called Incremental Load.

QlikView can connect to data base using ODBC connection created for the database.

A dashboard is a QlikView document which shows many matrices together and the values in the sheet objects can change dynamically upon selection of certain value in one of the Sheet Objects.

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 which a given date falls etc.

AGGR statement function produces a virtual table, with one expression and grouped by one or more dimensions. The result of this virtual table can then be used by a further outer aggregation function(s).

A Star schema is a data model in which one fact table is connected to multiple dimension tables though foreign keys

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.

QlikView creates a synthetic key when two or more column between tables are same. It does not impact the data or performance but it indicates a flaw in the data model design.

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.

A circular loop is created when the relationship between two tables can be established both directly and through another third table.

Returns a value corresponding to a timestamp with the first millisecond of the first date of the month containing date.

This function auto generates values between a given range of numbers.

Pivot Tables are used to present sum of values across many dimensions available in the data. For example showing the total sales figure for both the months and quarters in a years.

Bar Chart, Pie Chart, Line Chart, Gauge Chart, Pivot table, Straight table.

Yes. In QlikView script editor we have the option to extract data form a web file by giving the URL as the input.

It allows you to rearrange the columns in the Table box which is displayed in the Sheet.

Rotate Left, Rotate Right and Transpose.

There are three fields required to create a cross table. Qualifier field, Attribute Field and Data Field.

It Executes the current load script, including all script commands, such as Drop Table and reloads data to the active QlikView document. However, only those tables whose load and select statements are preceded by the Replace or Add prefix are reloaded.

By using the Table Viewer Option under file menu we can see the Tables and their relationships.

When we want to preserve the layout of a sheet to be used again, we export the sheet layout which creates a XML file without any data.

The WebView mode uses the internal web browser in QlikView to display the document layout as an AJAX page.

A selection indicator is used to indicate the type of association between the data present in different sheet objects. A green dot indicates selected values, blue dot indicates locked values and red dot indicates de-selected values in AND mode.

It searches for any string that contains bi.

Fuzzy search finds all the values according to their degree of resemblance to the search string. Which means, even if the spelling does not match character by character, those results will also be shown.

A bookmark in QlikView captures the selections in all states defined in a QlikView document. It can be saved and accessed later.

The User bookmark is saved in the user computer while the shared server bookmark is saved in the server and accessible to all the allowed users.

The alerts can be triggered in three ways. (a) Automatically when there is a change in data (b) Manually from a internal macro (c) External program running QlikView API.

(a) Form File (b) Inline

When connecting to a database using ODBC, if the data source only provides 32-bit driver we use this option.

A Hidden script is a part of the script that executes before the execution of normal script and it is protected by a password.

It is a ratio between the numbers of records with not null values to the total number of records.

It is ratio between numbers of distinct values found in the table as compared to total number of distinct values in the field whose subset ratio is required.

The default field names when inline data is inserted is – F1,F2,F3 etc. This can be edited.

The QVD file is a proprietary and optimized for minimum transformations inside QlikView but the QVX file has a open file format which shows both the table structure and the table data in it.

The Garbage option is used to mark and delete the data that is not required or that is jumbled and not useful.

The fill feature is used to fill in empty cells with values from adjacent cells.

The data in a table can be split by using the unwrap transformation.

Context cell expansion is used to expand the contents of one cell into several cells in the table.

The binary statement is used load the access and data parts of a QlikView document. It does not load the layout information of the document.

Yes we can. We can store an external file (audio/video etc.) using Bundle prefix in the QlikView document.

Yes. Using concatenate function.

We can use the statement Drop field A;

The IntervalMatch prefix to a Load or Select (SQL) statement is used for linking discrete numeric values to one or more numeric intervals.

The mapping table is a temporary table to provide a mapping of values forms one column in first table to another column in the second table. It has only two columns and it is dropped after script execution.

The Noconcatenate function forces two tables with identical fields to be treated as two separate internal tables.

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.

Using of ScriptErrorCount system variable.

24