QlikView is the Business Intelligence device utilized by the University of St Andrews. Information from various University frameworks is consolidated and introduced in a solitary dashboard in a simple and reasonable way.

QlikView dashboards at the University of St Andrews are based on the accompanying standards:

Dashboards must be successful to utilize
Dashboards must help clients in completing their assignments
Dashboards must give the correct sort of usefulness
It must be anything but difficult to figure out how to utilize a dashboard
It must be anything but difficult to recollect how to utilize a dashboard
To use QlikView, you don’t need specialized skill in data frameworks, only a readiness to figure out how it can bolster you.

Clarify Set examination in QlikView?

It is utilized for set of gatherings. For the most part utilized in collected capacity like total (year., and so forth. Experience this keen blog to realize why QlikView is such an extraordinary Business Intelligence instrument.

Characterize Trellis Outline?

In Trellis outline we can make exhibit of diagram dependent on first measurement. Bitmap diagram are likewise made of trellis show.

What is Pivot Table?

Rotate Table:
A rotate table is better at the season of collection. We can likewise demonstrate rotate table like a cross table which is a helpful element. Be that as it may, there is one detriment of it which is on the off chance that we need to sort a rotate table than we need to sort it initially as indicated by the main measurement then to the following.

Which diagram we will use for a long-time distinction deal?

Structured presentation we will utilize.

How we can utilize Macros in our application?

We can utilize macros for different purposes like for reloading the application and to make object.

What do you comprehend by layers in QlikView?

The layer are fundamentally determined to the sheet object properties format where base, top, typical particular to the number – 1,0 and Experience this canny Infographic to find out about the qualities of QlikView now.

What is Dimensions?

Measurements permit information examination from different points of view.

What Is Star Schema?

The least difficult type of dimensional model, in which information is prearranged into certainties and measurements is known as Star diagram.

What is Snowflake Schema?

A snowflake pattern is a distinction of the star blueprint. Snowflake is utilized to enhance the introduction of specific inquiries.

What are the new highlights in V 11?

Holder Object; Granular Chart Dimension Control; Actions like, clear documented; meta data,etc are the new highlights in V 11.

Clarify joins and its sorts?

Join is utilized to change over the given information and at whatever point we are utilizing joins for changing over information its is known promotion Data Merging.
It has numerous sorts:

Left join
Right join
Inward join, and so forth

Clarify Identifiers Syntax?

0-Represents the unfilled set
1-Represents the full arrangements of records
$-Represents the record of current determination
$1-Represents the past determination
$_1-Represents the following determination
Bookmark01- means the Bookmark name

Clarify 3-level engineering of QlikView Application?

QlikView stores the information in QVD as QVD has information pressure ability. QlikView has preferred execution over other BI in light of its memory investigation approach.

Clarify the confinements of Binary load for a QlikView Developer?

Parallel Load can be utilized for just a single application implies we can just peruse the information from one QVW application and additionally set contents is likewise a confinement.

Characterize engineered Key?

Engineered key is where at least two tables comprises more than one normal section between them is called as manufactured key.

What is gradual load in QlikView Architect?

Steady load is only stacking new or changed records from the database. With the assistance of QVD records we can utilize gradual Load.

Separate among set and let alternative in QlikView?

Set: it allots the variable without evaluates the articulation.
Let: it allots the variable with evaluates the articulation.

Characterize apply outline.

apply outline used to add fields to the tables with the assistance of different tables. It very well may be utilized as joins.

What is link?

It implies arrangement of interconnected things i.e. any section or line which is identified with one another can be associated through link.

Characterize No Concatenation.

No Concatenation prefix is utilized to constrain the indistinguishable tables as two separate interior tables.

Characterize associate articulation.

It is utilized to set up an association with database with the assistance of ODBC or OLEDB interface.

What do you comprehend by preview perspective of the table?

By this choice we can see number o tables and related affiliations.

How we can bring information into v?

We use ODBC, OLEDB, SAP connectors sort of information associations.

How we can deal with Early Arriving Facts.

We can stack information from ODBC, OLEDB, SAP connectors, by select articulations and we can likewise stack records like exceed expectations, word, and so on by utilizing Table Syntax.

What sort of information we for the most part use?

We utilize level documents, exceeds expectations, QVDs, and so on advertisement information.

Can you write Incremental load script?

// First we have to load the tale and create one QVD
Table name:
LOAD Primeid,
[food category],
[food item],
location,
lastupdate
FROM
[C:\Users\QlikView\Desktop\EMP.xlsx] (ooxml, embedded labels, table is Sheet1.;
STORE FOOD into FOOD.QVD(QVD.;
//save the QVW and Reload.
// once the reload done enter to edit script and write down below script
Final Script:
Table name:
LOAD Primeid,
[food category],
[food item],
location,
lastupdate
FROM
[C:\Users\QlikView\Desktop\EMP.xlsx] (ooxml, embedded labels, table is Sheet1.;
// Load QVD As we created and concatenate the table and QVD…
concatenate
LOAD Primeid,
[food category],
[food item],
location,
lastupdate
FROM
[E:\QVW\FOOD.QVD] (QVD. Where not Exists(Primeid.;
//Once Concatenation is done load same table only Primary Key field and create one inner join like below..
Inner Join
LOAD Primeid
FROM
[C:\Users\QlikView\Desktop\EMP.xlsx] (ooxml, embedded labels, table is Sheet1.;
STORE FOOD into FOOD.QVD(QVD.;
// Finally Store QVD

How to find QVD for which QVW loaded Data?

open the QVD file in a text editor, notepad will do, and you can see which QVW was used to create the file in the <CreatorDoc> tag.

How generate the table in QlikView without loading any tables from source?

yes we have option to load data within the script using Inline load.
Example: edit script —> insert menu —> Load Statement –> Load Inline.
here we can generate the data.
load * inline [
A,B
1,AA
2,BB
3,CC
];

How many types of Bookmarks Available in QlikView?

QlikView Have 4 Types of Book Marks They Are

Document Bookmarks.
User Bookmarks.
Private Server Bookmarks.
Shared Server Bookmarks.

How you find-out Duplicate records In QlikView?

we can able to find-out Duplicate values Using count function.
Sum(Aggr(if(count(fieldname.>1,1,0.,Fieldname..

How to hide column in pivot table? and is this possible to hide the column in Straight Table?

In QlikView hide column option not available in pivot. But if we can Wright a Macro its possible.
Straight Table we have option to hide the column, Go to straight table Properties—-> Presentation Tab —-> check the Hide Column Option (first select which column you need to hide then check the Hide column Option.

Is this Possible to find-out All Expressions In a QVW File?

Yes We Can able to see Expressions in One Place Settings —> Expressions Overview.

How to change the expiration Values Colors in Pivot Table?

we can change the values colors in visual cues tab we can give upper value and Lower values.
or select the expiration and Expand the Expiration and select Text Color in that description use If Condition we can change.

How to Change the Sub Total Row Color?

Select The Dimension And Expand the Dimension And Select background color in that description write Below Exp.
if(Rowno(. = 0,green(..
here in pivot Chart Rowno(.=0 is v treat like subtotal row

How we can perform two Employees Comparison using Alternative State?

Yes We can able to create Comparison of two employees using Alternative State .
first we need to create Alternative State in document properties in General Tab Press Alternate State Button And Create Two States.
And Take Two Filters taking EMP Names Column and Apply Alternate States One Is One filter and Second One Is Second Filter.
Create Bar chart And Write Exp Like Below.
Example 1:
Sum({State1 * $}Sal.
this One will Show First filter Selected Employee Sal
Example 2:
Sum({state2 * $}sal.
this one will Show Second Filter Selected Employee Sal in Same Bar Chart.

What is the error codes and observations in QlikView?

No error
General error
Syntax error
General ODBC error
General OLE DB error
General custom database error
General XML error
General HTML error
File not found
Database not found
Table not found
Field not found
File has wrong format
BIFF error
BIFF error encrypted
BIFF error unsupported version
Semantic error
Error Code 3 = General ODBC error.

How many services are available in QlikView?

V Have total five Services they are

V Management Services
V Server Services
V Distribution Services ——> V Publisher Services
V Directory Service Connector
V Web Services.

How you can write Error Script?

set ErrorMode=0;
load * from A;
if ScriptErrorCount >1 then
Load next;
end if

Write a Master Calendar script?

First we have to load the source table then find-out the min date and max date and assign to variables. In between min and max dates we have to generate the calendar dates, using below script.
LOAD DATE(MINDATE+IterNo(. -1. AS DATE WHILE (MINDATE+IterNo(. -1.<= NUM(MAXDATE.;
LOAD MIN(Date. AS MINDATE,
MAX(Date. AS MAXDATE Resident Wipro;
Based on this Table you can find-out week, uarter, Year, Month and YTD Etc.

How to show Table fields in list Box?

=Aggr(Only({1<$Table = {‘Table name’}>} $Field., $Field.

How many types of triggers Available In V?

We have 3 Types of triggers Available in QlikView.

Document Triggers
Sheet Triggers
Server Triggers

Document Triggers:

In this Document triggers Have Multiple Triggers

Document Event Triggers:-

On Open
OnPostReload
OnEnyselect
OnPostRewduseData

Field Event Triggers:-

OnSelect
OnChange
OnLock
OnUnlock

Variables Event Triggers:-

OnChange
OnInput

2. Sheet Triggers:
OnActiveSheet
OnLeaveSheet

3. Server Triggers(MC.:
On A Schedule
On Event From Other Task
On External Event
On Multiple Events Complete

How to create Key Table In QlikView?

While loading time QlikView get Some Synthetic keys , we can create key Table and resolve the synthetic keys.
load Two tables and create one field in two tables using AutoNumberHash256(..
load the common fields as well as created field using resident in two tables.
once this complete drop the common fields in two fact tables.
reload the QVW and See Data Model using Ctrl+T we have created key table.

Which key word you can write for Section Access?

In Edit Script we should write below two key words for applying Section Access
Section Access;
Load Section Access Table
Section Application;

What is Narrative science in QlikView?

The Narrative science in QlikView is provide the word formatting Analysis like to explain the Report using object.
we have Extension For this use that one and create the Object and just select the chart V Automatically provide Sentences for that Report.

We have one scenario that is like we have data in one column like rows but we want data in one row with coma separated how you achieve this?

If we have data like columns rows data if we want coma separated data using those columns I will use subfield function.
Subfield (column name,’,’.

How to show two KPIs data in one Text object?

For this I will write expressions in one text object using this &’ ’&.
=sum(sales. &’
‘& avg(sales.

Can you elaborate Set Analysis?

Set analysis is a main part in frontend, set analysis we implement combination of Identifiers, Operators and Modifiers. they are like bellow.
$,1, $1, $2 these are identifiers and *, -, + and / these are Operators
Tables columns we consider as modifiers.

We have script like sum(tyamount – tyDiscount amount. how you can optimize this in application?

Yes we can do this in load script we can calculate and the we can sum it in frontend
Script level: ty*amount – ty*Discount amount as TYamount
In KPI we can use like below.
Sum(TYamount.

Scenario is we have 2 years historical data in QVD but the data changed only Dec month so is there any way to insert only updated data?

Yes, we can do-it using where exist function.

We have two filters and two charts as Clint require when they selected one filter its need to reflect only one chart 2 chart should not change as per selection how you can achieve?

Yes, we can achieve two ways one is throw set analysis and other way is Alternate state.

We can exclude particular field selection like below

Sum({<Year=>}Sales. when we wright like this when you select any year from that field this chart won’t change

One more is just create Alternate state and apply for one filter and one chart.

Given the following script, if we execute the script what is the output result?

Customer:

Load*Inline [

CustomerID, Customer

12, Hema

13, Latha

];

Order:

Load*Inline [

OrderDate, CustomerID, Price, ty

10/3/2020, 12, 500, 6

12/2/2019, 12, 600, 7

15/1/2018, 13, 200, 3

07/6/2017, 13, 400, 2

];

Customer and Order table will be loaded as separate table
Customer table will be linked with the order table
Order table will merge with the customer table
Order table will forced concatenated with the Customer table
Customer and Order table will be loaded as separate table

What does the following function do text (‘314’.?

A. 3

B. 1

C. 4

D. 14

I have data like ’12ax34e5′ here i want remove Alphabets How to find out in V?

A. Purge char(.

B. Keep char(.

C. Char(.

D. Purge

(A.Purge char(‘String data’,’a,b,c,d,….,z’.

What are two ways to calculate the Sales for the Product Category, Shoes? (Select two..

A. Sum (<Product Category= {‘Shoes’}>Sales.

B. Sum ({<Product Category = {‘Shoes’}>} Sales.

C. Sum (<Product Category = {Shoes}>Sales.

D. Sum ({< {Product Category} =‘Shoes’>} Sales.

E. Sum ({<Product Category= {Shoes}>} Sales..

B & E

To represent the previous year sales performance in a simple KPI object.

Which expression should be used to calculate this value?

A. Sum ({<Year= {Max (Year.-1}>}Sales.

B. Sum (Aggr (Sum (Sales., Max (Year.-1..

C. Sum (Aggr (Sum (Sales., Max (Year-1…

D. Sum ({<Year = {$(= Max(Year.-1.}>}Sales.

Data architect needs a KPI to show sales of all years since year 2000. Assume the current is 2019

Which expression should the data architecture?

A. Sum ({$<Year={“2*”}>}Sales.

B. Sum ({$<Year={2000+}>}Sales.

C. Sum ({$<Year={“>2000”}>}Sales.

D. Sum ({$<Year={2000-2017}>}Sales.

Refer to the exhibit:

Section Access;

Load *Inline [

ACCESS, UserID, REGION

Admin, domain\A, North

Admin, domain\A, west

Admin, domain\B, East

Admin, domain\C, *

Admin, domain\D, *

];

Section Application;

Load *Inline [

Region,

North,

West,

East,

South

];

Which values of the region field will be visible for UserC when the user opens the app?

A. East, West, south

B. North, East and West

C. North, East, West and South

D. West and East

The Source of data like customers table having CustomerID, CategoryName field value having Men’s Footwear. How to calculate the count of CustomerID without the field value of Men’s Footwear by using set analysis?

Count (distinct {$< [Customers. CustomerID]= E({1< CategoryName={‘Men’s Footwear’}>}.>}[ Customers. CustomerID].

What is the way to calculate the sum of LineSalesAmount, Years 2014 to 2019 and Month staring with J selected with other selections?

Sum ({$<Year= {‘>=2014<=2019’},Month={‘J*’}>}LineSalesAmount

To calculate the Salespeople of Year 2015 and 2017 are always selected?

Sum ({<Year= {2015, 2017}>} Salespeople.

To execute the below code:

Load * Inline [

CustomerID, Name

1, Hema

2, Latha

3, Harish

4, Anu

];

Load * inline [

CustomerID, Name

5, teju

6, Sukku

7, Vishu

];

While loading two tables cannot intersect with each other. How to find out in V?

A. Join

B. Outer Join

C. Concatenate

D. NoConcatenate

120.

Orders:

Load OrderID,

CustomerID,

Amount

From

[lib://Test1/orders.xls]

(biff, embedded labels, table is Orders$.;

How to store the Orders table in to QVD?

A. STORE Orders into[lib://Test1/orders.QVD](QVD.;

B. STORE Orders in[lib://Test1/orders.QVD](QVD.;

C. STORE Orders into[lib://Test1/orders.QVD];

D. STORE Orders into[lib://orders.QVD](QVD.;

How can I capitalize only the first letter of a string?

Given the string below: besant technologies

A. Capitalize(‘besant technologies’.= Besant Technologies

B. Uppercase(‘besant technologies’.

C. Lowercase

D. None

How to renaming the Orders table into Order1 new table in V?

A. Rename Table Orders to Order1;

B. Rename Table Orders to Order1

C. Rename Table Orders into Order1

D. Rename Table Orders into Order1;

Refer the following table:

Month

Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct

In this case Match(Month,’Feb’. and WildMatch(Month,’J*’.. What should be the result of both Match & Wildmatch Case?

A. Fe and Jan,Jun

B. Feb and Jan,Jun,Jul

C. Jan and Feb

D. Jan,Jul and Feb

In QlikView, what are the objects having only expression and no dimension?

Gauge chart and list box are the objects having only expression and no dimension.

Explain join and its types

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

What are CAL and its types?

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

How can you bring data into V and handle early arriving facts?

By using ODBC, OLEDB or SAP connectors as a data connection, we can load data using Select statement.

What is the use of Comparative Analysis in the QlikView Developer Platform?

By using the Comparative Analysis option, users can quickly gain new insights to analyze their information in QlikView.

In QlikView, what is the use of an optimized load?

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.

What is Incremental load and Resident load?

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.

Is it possible to load web files into QlikView? If so, how?

Yes, it is possible to load web files into QlikView. It is done through the Script Editor.

What is Inline data? How can we load Inline into QlikView?

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.

What are Sheets in QlikView?

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.

In how many ways can the Script Editor be invoked?

Script Editor can be invoked in two ways- either by the shortcut keys Ctrl+E or by the icon for Edit Script.

What is a Dashboard?

A dashboard is a QlikView document which displays values from many fields simultaneously and makes the analysis process easier.

What is buffer load, and why is it significant?

A buffer load is used to create a file using a buffer prefix in QlikView’s memory for future use.

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.

What does the Auto-Generated function do in QlikView?

Auto-Generated function automatically generates the numbers between the given range.

What are the parameters needed by a crosstable Wizard to form a cross table?

A total of three fields are required to create a cross table, and they are as follows: Attribute field, data field, and qualifier field.

What are the advantages and disadvantages of QlikView?

Advantages

Data sharing
Data interpretation and analysis
Self-service tool
Low Maintenance
Data security
Direct and indirect search
Cheaper

Disadvantages

Inefficient real-time data analysis
Less RAM limit

What are the types of authorization in QlikView?

Authorization is nothing but permitting the users to access the resources. In QlikView, authorizations are implemented at multiple levels such as-

Document-level
Data level
Sheet Level
Chart level
Column level

What is interval match?

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.

What are the new features in V 11?

New features of V are as follows-

Container Object-Grid Style
Conditional enabling of dimensions and expressions
Metadata
Granular Chart
Comparative analysis

Difference between QVD and QVW?

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.

What is the difference between Pick and Match?

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.

What is the difference between RDBMS and Associative Data Model?

RDBMS: stands for Relational Database Management System, and it stores data into rows and columns of tables and data is retrieved through SL ueries. An associative database model is comprised of two tables: one for items and one for links.

What is the purpose and Uses of QVD files?

To increase load speed
Incremental Load
Ease of Maintenance
Consolidating data
Separation of Roles
Decreasing load on database servers

What are the types of QVD Creation?

By using Store command

By using buffer before load/select

via UI-[chart export]

What are CAL and its types in QlikView?

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

Name some databases that QlikView can connect to.

Oracle, SL Server, MySQL, Progress, DB2, MS Access, Informix, etc.

What Are the Main Features of QlikView?

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

What are the different services of the QlikView Server Environment?

MS (QlikView Management System.
VS (QlikView Server.
QVWS (QlikView WebServer.
DS (QlikView Distribution Services.
DSC (Directory Service Connector.

What do you understand by associative nature of data in QlikView?

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, in a QlikView document related to sales. 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.

What operations can you perform using the Tools menu given in the Menu bar?

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 managed through this menu which are Alerts and Themes making.

On what levels can you manage the settings from the Settings menu?

The Settings menu provides managing the settings and properties of three main factors of QlikView which are; User settings or preferences, Document Properties and Sheet Properties. Apart from this, the Settings menu provides an option where we can view all the available variables and expressions used in QlikView.

What do you understand by Delimited files? Why are they called CSV files?

A delimited file is a simple text file in which the data fields and field values are separated by a comma, semicolon, tabs etc. Such files are called CSV files where CSV is short for Comma Separated Values. CSV files are saved in .csv extension.

What are XML files? How can you load XML files into QlikView?

XML stands for Extensive Markup Language. It is a markup language for data and contains tags for data values storing structure and meaning of data. XML files carry the extension .xml.

To load an XML file into QlikView, go to the Edit Script the click in Insert option. Next, select Load Statement and then select Load from File option. A dialog box will appear from where data files can be browsed and selected.

What is Inline data? How can we load it into QlikView?

Inline data is the data set that you can define as well as load in QlikView itself. Inline data is created on the spot and is not loaded from an external data file.

To load inline in QlikView, open the Script Editor and select the Insert option. Then select Load Statement followed by selecting Load from Inline. A dialog box having an empty table will open where we can enter our data values.

How can we connect to a database from the script editor?

At the bottom half of the script editor, a section named Database is present. We can connect to a database by the selecting the connection method from ODBC or OLE DB and then clicking on Connect. Then, we have to select a Data Source Name (DSN. from the list of databases available and that database will be connected to QlikView.

Name some databases that QlikView can connect to.

MySQL, Progress, Oracle, SL Server, DB2, MS Access, Informix etc.

What is Resident Load?

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

What do you understand by QVD files?

QVD files stands for QlikView Data files. Such data files contain tables having data created in or exported from QlikView. QVD files are exclusive to QlikView and can only read and written in QlikView.

Discuss the importance of QVD files in QlikView.

QVD files serves as a storage or container file that stores data for future use. The role of QVD files between the front end and the back end is that of transition files i.e. data files loaded from database and are stored in QlikView’s memory as QVD files so that it is easier and faster to fetch data from memory (as QVD files. than having to connect every time to the database. At the front end, QVD files are converted into qvw files.

How many types of charts can be created in QlikView?

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.

In what ways can the Script Editor be invoked in QlikView?

Script Editor can either be invoked by the icon for Edit Script or by shortcut keys Ctrl+E.

How can you reload a script?

A script can be reloaded after making changes by the shortcut keys Ctrl+R or by the icon given on the toolbar for Reload script.

What is Null(. function?

The Null(. function returns a real null value.

Give some date and time functions.

Today(., localtime(., month(., year(., makedate(., timezone(., GMT(., day(., week(., month(., year(..

Compare QlikView with Tableau.

Criteria	Tableau	QlikView
Performance	Uses a cubing technique that gives out results slower than QlikView	Faster than Tableau as it effortlessly combines all sizes of datasets
Interface	Comes up with a simple drag-and-drop interface that is easy, clean, and interactive	Has too many tools that are rarely used but certainly provide numerous ways for showcasing data
Suitable for	Provides dashboarding and rapid visualization	Offers departmental and enterprise-wide BI solutions
Product range	Has diverse products for varied uses	Has a single product for the entire BI solutions
Geographical maps	Building map visualization is easy with its in-built extension	Building map visualization takes longer since it needs scripting and an external extension for this
Tables	Weaker for tables	Very good for tables
Speed	Depends on RAM and the source database	Depends on RAM
Graphical inputs and changes	With easy drag and drop, graphical inputs are easy	For graphical changes, we will have to write the logic for it

What is Pivot table?

A pivot table is better at the time of grouping. We can also show a pivot table like a cross table, which is a beneficial feature. However, there is a disadvantage with pivot tables, i.e., if we have to sort a pivot table, then we have to sort it first according to the first dimension, then to the next.

Which graph can you use for 2 years’ difference sale?

A bar graph can be used for this purpose.

What is Straight table?

A straight table is much better at the time of sorting when compared to the pivot table as we can sort the former according to any column as per our choice. However, it is not good for the grouping purpose.

What are Dimensions?

Dimensions allow data examination from various perspectives.

Explain Normalized data.

Normalized data: By saying normalized data, we mean the well-structured form of data, which doesn’t have any repetition or redundancy. It is a kind of relational data mainly used in OLTP-like stuff.
Denormalized data: Along with normalized data, we have denormalized data as well. It is a whole bunch of data without any relationship among themselves, with the possibility of redundancy. It’s mainly used in OLAP-like stuff.

What is Star Schema?

Star schema is the simplest form of a dimensional model, in which data is pre-arranged into facts and dimensions.

What is Snowflake Schema?

A snowflake schema is a different form of the star schema. A snowflake schema is used to improve the presentation of particular queries.

Explain Join and its types.

Join is used to convert the given data, and whenever we use joins for converting data it is known as data merging.
It has many types:
a. Left join
b. Right join
c. Inner join, etc.

What is Left Join?

Left join specifies that the join between two tables should be left join; it uses before the word ‘join’. The resulting table only contains the combination among two tables with the full dataset from the first table. When we have more than one common field between two or more tables, then we have synthetic keys.

Define Right Join.

Right join specifies that the join between the two tables should be right join; it uses before the word ‘join’. The resulting table only contains the combination among two tables with the full dataset from the second table.

Explain Inner Join.

Inner join specifies that the join between the two tables should be inner join. The resulting table should contain the full dataset from both tables.

What are Modifiers?

Modifiers deal with the Fields name.

Example:

sum({$<Region=>}Sales.

The above code returns the sales for the current selection, but the selection in ‘Region’ is removed.

Explain the restrictions of Binary Load for a QlikView Developer.

Binary Load can be used only for one application, i.e., we can only read data from one QVW application. Moreover, set scripts is also a restriction.

For a QlikView Administrator, differentiate between Subset Ratio and Information Density.

Subset Ratio: It is used for easily spotting problems in the key field association. It is only relevant for key fields as they are present in multiple tables and do not share the same value.
Information Density: It is the field that contains the percentage of rows with non-null values.

What is the use of Optimized Load?

Optimized load is much faster and preferable especially for large sets of data. It is possible if no transformation is made at the time of load and no filtering is done.

How can you optimize a V Application?

A V application can be optimized by creating QVDs for data. When the complete QVW application is changed into a QVD, then this QVD will be stored in the RAM.

What is Mapping Load?

Mapping load is used to create the mapping table that can be used for replacing field values and field names.

Define Apply Map.

Apply map is used to add fields to tables with the help of other tables. It can be used as a join.

What do you mean by RDBMS?

RDBMS stands for ‘Relational Database Management System.’ It arranges data into respective columns and rows.

What do you understand by the term ‘CAL’ in QlikView Server?

Every client needs a CAL to get connected with QlikView Server. CALS are taken up with QlikView Server and tied up with the server serial number.

Differentiate between QlikView Server and QlikView Publisher.

QlikView Serveris a program that is installed on a computer with various CALS allowing users to access the V files on the server.
QlikView Publisheris a program that has centralized control on our V files and manages how and when they are loaded and distributed.

What do you understand by the Snapshot View of a table?

By this option, we can see a number of tables and related associations.

How can you bring data into V?

We can use ODBC, OLEDB, or SAP connectors as a kind of data connection.

What are the benefits of using QlikView?

As the name suggests, QlikView is a combination of ‘quick’ and ‘click,’ and its features make it intuitive and easy to use. Users can visualize data, search in multiple datasets, create ad-hoc reports, and view patterns and trends in data that may not be visible in other reports.

QlikView is:

Flexible: Dashboards are web-based and accessible from desktop computers and mobile devices.
Interactive: Users are able to easily drill down and select particular data from charts or tables.
Usable: Users can see large amounts of data effectively and efficiently.
Scalable: QlikView is useful for multiple business processes at analytical, operational, and strategic levels.

How is QlikView 11 different from QlikView 10?

QlikView 11 brings new levels of capabilities and manageability to the QlikView Business Discovery platform. In this release, it has focused its investments on five value propositions:

Improve collaborative decision-making with Social Business Discovery
Gain new insights into opportunities and threats and relative business performance with comparative analysis
Expand QlikView usage to additional devices, including smartphones, with mobile Business Discovery
Enable a broad spectrum of users to jointly develop QlikView apps with QlikView’s rapid analytic app platform capabilities
Improve the manageability and performance of QlikView with new enterprise platform capabilities

For a QlikView Admin, what is Document-level Auditing in QlikView 11?

New optional settings within QlikView Management Console enable administrators to more effectively audit user interactions. Administrators can now audit QlikView usage not only at the system level (the entire QlikView Server. but down to the document level as well.

What are the key differences between QlikView and any other standard statistical software packages (SAS, SPSS, etc.?

The key difference is in terms of the database used. While SAS is useful in the case of metadata and SPSS is good for analysis; QlikView offers quite a simple visualization that matches MS Excel filtering.

When comparing QlikView with the other two, it is the most user-friendly and the fastest in terms of generating diverse dashboards/templates.

In terms of calculations, advanced statistics options are limited in QlikView.
For market research and analysis, SPSS has direct facility algorithms.

What are QlikView Annotations?

With the new annotations collaboration object, QlikView users can engage in threaded discussions with the QlikView content. A user can create notes associated with any QlikView object. Other users can then add their own commentary to create a threaded discussion.

Users can capture snapshots of their selections and include them in the discussion so that others can get back to the same place in the analysis when reviewing notes and comments. Also, QlikView captures the state of the object (current selections., as well as knows who has made each note and comment and when and how a decision was made.

What sort of outline we use in QlikView Admin?

We for the most part utilizes bar outline, line diagram, combo graph, disperse diagram, framework graph, and so on.

Clarify Mini Chart? I’m not catching your meaning by sub reports and how we can make them?

With the assistance of Mini Chart we can set kind of modes rather than qualities in table mode. We can likewise change the colors.Read this QlikView Tutorial to take in more about QlikView now.

What is Straight Table?

A straight table is vastly improved at the season of arranging when contrasted with the rotate table as we can sort it as per any section according to our decision. In any case, it isn’t useful for gathering reason.

What number of measurements we can use in Bar diagram?

We can utilize just two measurement

Which QlikView object has just articulation and no measurement?

Check outline and rundown box have just articulation and no measurement.

Clarify about Normalized Data?

Very much Structured Form of Data, which doesn’t have any reiteration or excess of information. It’s a sort of Relational information. It’s for the most part utilized in OLTP sort of stuffs Denormalized Data – It’s an entire cluster of information with no relationship among themselves, with excess of information. It’s fundamentally utilized in OLAP sort of stuffs.

Clarify interim match?

The inner match is prefixes with the heap articulation which is utilized for interfacing diverse numeric dualities to at least one numeric interim.

Clarify inner match work ?

Interior match work is utilized to create information container of various sizes.

What is Container?

A holder object is utilized to keep numerous graphs. We can utilize a compartment item to keep numerous diagrams in a similar box.

What do you comprehend by expanded interim match work(.?

Broadened interim match work (. is utilized for gradually changing the measurements.

What is Left Join?

Left join indicates that the join between the two tables ought to be left go along with, it utilizes before the word join. The subsequent table just contain the blend among two tables with the full informational index from the main table. When we have more than one regular field between at least two tables then we have engineered keys.

Characterize right join?

Right join determines that the join between the two tables ought to be correct go along with, it utilizes before the word join. The subsequent table just contain the mix among two tables with the full informational collection from the second table.

Clarify Inner Join?

Inward join indicates that the join between the two tables ought to be internal join. The subsequent table ought to contain the full informational collection from both the sides.

What are modifiers?

Modifiers manages the Fields name.
For instance: sum({$<Region=>}Sales.
Returns the deals for current determination, however with the choice in “District” is expelled.

For a QlikView Administrator, separate between subset Ratio and Information Density.

Subset Ratio: It is utilized for effortlessly spot issue in key field association.it is significant for key fields since they are available in numerous tables and don’t have a similar esteem.
Data Density: It is the field which contain the level of column which contain the non-invalid esteem.

What is the utilization of Optimized Load?

Upgraded stack is a lot quicker and ideal particularly for huge arrangement of information. It is conceivable if no change are set aside a few minutes of load and no separating is finished.

Separate among keep and joins?

Keep and joins do similar capacities yet in keep makes the two tables though join just makes the one table. Keep is utilized before the heap or select proclamations.

Characterize QlikView Resident Load.

Occupant stack is a piece of stacking information in QlikView application. It is utilized for stacking information in tables which is as of now stacked in QlikView application.

How we can streamline V application?

It very well may be advanced by making the information into QVDs. At the point when finish qvw application is changed into QVD than this QVD will be store in the RAM.

What is mapping load?

Mapping load is utilized to make the mapping table that can be utilized for supplanting field esteem and field names.

What do you comprehend by Fact group of stars Schema?

It is a consistent database structure of information Warehouse . It is structured with the assistance of De Normalized Fact.

I’m not catching your meaning by RDBMS?

It represents social Database the executives System. It organizes the information into particular section and lines.

What do you comprehend by the term CAL in QlikView Server?

Each customer needs a CAL to get associated with QlikView Server. The CALS are taken up with QlikView Server and tied with the server sequential number.

Separate between V server and Distributer?

V Server is a program that is introduced on PC with different CALS which enable client to get to V Files on the server. Distributer is a program which oversees brought together control on our V documents and oversees them how and when they are stacked and dispersed.

Can You tell me the Cross-table Syntax?

This table contains Attribute field and Data fields and No of qualifiers and contained load statement.

We have (VPR. repository in QMS, how you can move data to data base?

System Tab We have to select QlikView Management Services(MS. in that repository Tab we need to select Repository Type XML Repository give Database Name AS VPR and then give Optional Path for creating Data Base. check the migrate data from current repository Option. then Schedule the Backup Settings based on requirement.
Note: Files will Store only Zip Format.

What is exist(. Not Exist(., can explain ?

Exist(. is used commonly in where clause is the values need to load whatever we have already in QVD those records need to load that time we are used Exist(. function.
Not Exist(. these function we are used for Update and delete records updating in QVD. these also we are using where clause.

How to find the total No Records in a QVD?

we have one function to find-out the QVD records no using below Function.
QVDNoOfRecords (‘path with filename’.

How to Find Out Particular Product % From All the Products?

Using Pivot We can able to see use dimension is Product and Exp is Sales

What are the different variables in QlikView?

In QlikView we have two types of Variables they are
1. SET
2.LET.

SET: this is static variable these variable we can able to create in edit script only.
this only use for constant values, set variables not able to do evaluations.
EX:   set variable = ‘sathish’;   // here it’s shows Sathish.
a=10
b=20
set c=a+b      // here its display a+b only because set variable not able to do caluculations.
LET: this variable is dynamic variable, it’s Possible To evaluate the values like below, and front end also possible to create LET Variables.
a=10
b=20
Let C=a+b   // here let variable will gives addition of a+b value 10.

How you can achieve the values showing in bar chart?

Chart Properties —> Expiration Tab –> Check the Values On Data Points Option .
If you want to show values on inside the bar Go to Presentation tab—> Select Plot values inside the segment option.

Which function works look like SL ‘IN’ Operator in QlikView?

In QlikView Match (. works Like SL IN Operator.
Match (. is Case Sensitive, if your Passing First Argument Is Capital letter and values are small letter it will display 0.

How to show multiple Expressions in Text Box?

we can able to show multiple Expressions In Text box using ‘& &’

How to Create Dimensions in Front End?

we can able to create Dimensions in Front end using Customized Dimensions.

I have data like ’98as32r9′ here i want remove Alphabets How to achieve in QlikView?

Here we can use Purgechar(. function to remove Alphabets in string.
Purgechar(‘String data’,’a,b,c,d,….,z’.

How we can achieve Dimension Limit In Pivot table?

yes we can able to achieve the Dimension Limit in Pivot table.
Dimension Tab —> Calculated Dimension —> here we need to write a condition like below
=if(Aggr(rank(sum(sales..,ProductID, SalesmenID.<=5,SalesmenID.

Tell me the Diff Between Date and Date# ?

Date(.: this is for formatting the date.
Date#(.: this is for identifying the Date format.
For Example: we have a table contains the Deferent Date Formats this one need to convert one format that time we have to use both functions, first we should find out date formats then need to convert date.
Date(Alt(Date#(Column,’DD-MM-YYYY’.,Date#(column,’DD.MM.YYYY’..,’DD/MM/YYYY’.

We have some old script and need to add new script while loading time it’s getting error (Execution of script failed. Reload old data”. what you have to do?

We have to check all script old and new separately if it’s working fine we need to copy whole old script and new script to new QVW file it will work , and need to copy all Frontend Designing’s also.

How to Share Object to Users?

yes the creator of the object can enable the sharing of the object with either everyone or to specific users.
Then other users can drag and drop that object from Repository. (an icon available on the document tool bar on Access Point.

How to find- out the data model in QlikView and how many types of views available in QlikView?

In QlikView we can see data model in Table viewer, these two types

Source Table View
Internal Table view

QlikView Assess point not Getting its Showing No Server what we need to do?

Here we have done First Restart the Web Server Services but not Resolved That time I have solved this issue by running repair option in VS setup. Re applied my QlikView server License. QlikView server is up and running.

How to paste extensions in Qlik Sense?

We must download the extensions from GitHub or Qlik bench then we need to paste in our desktop in the below location.
C:\Users\SatheshKumarE\Documents\lik

How the business analyst to present one slide story and its should be change the selection how you can achieve?

First create a story and then add a sheet from the sheet library that contains the visualizations.

How to show the KPI with the sum of sales of all years since year 2000, lets assume current Year is 2019?

Yes we can achieve this using set analysis like bellow.
Sum({$<Year={“>2000”}>}Sales.

Given the following script, if we execute the script. what is the output result?

Customer:

Load*Inline [

CustomerID, Customer, Year

12, Hema, 2020

13, Latha, 2018

];

Order:

Load*Inline [

OrderDate, CustomerID, Price, ty, Year

10/3/2020, 12, 500, 6, 2020

12/2/2019, 12, 600, 7, 2019

15/1/2018, 13, 200, 3, 2018

07/6/2017, 13, 400, 2, 2017

];

A. Customer table will be linked with the Order table but through a synthetic key table containing all the fields from Customer table

B. Customer table will be linked with the Order table but through a synthetic key table containing CustomerID and Year field

C. Both 1 & 2

D. None

In the following scenario:

Set vS = 2+3;

Let vL = $(vS. & ‘+1’;

What would be value of vL?

A. 6

B. 2+3+1

C. 5+1

D. 5

How to show two KPIs data in one Text object?

For this I will write expressions in one text object using this &’ ’&.

=sum (amount. & avg (amount.

How to show the KPI with the sum of sales of all years since year 2000; let’s assume current Year is 2020?

A. Sum ({$<Year= {“>2000”}>} Sales.

B. Sum ({$<Year= {“>2002”}>} Sales.

C. Sum ({$<Year= “>2000”}>} Sales.

D. Sum ({$<Year= {“>2000”}> Sales.

When the script is loaded, what is the value of vV2?

Set vV1= 2+3

Let vV2=2+3

A. 5

B. 2+3

C. 9

D. 10

Find out top 5 earners of company.

SL>select * from (select * from emp order by sal desc. where rownum<=5;

Display the Employee name and Managers names.

SL>select e.ename employee, m.ename manager from emp e, emp m where m.empno=e.mgr;

OrderID, OrderDate

101, 20160502

102, 20170203

103, 20190405

The source of date field is being loaded as numbers.

Which function should the data architect use to fix the issue?

A. Timestamp

B. Date

C. Date#

D. Timestamp#

To calculate sum of revenue for previous year, we are having data fields year, month, fieldname

A. =sum ({$<Year=, Month=, Date Fieldname= {‘>=$(=YearStart (Today (., -1.. <=$(=AddYears (Today (., -1..’}>} Revenue.

B. sum ({<Year= {$(=Only (Year..}, Month= {“<=$(=max ({<Year={$(=Only(Year..}>} Month..”}>}Revenue.

C. None

D. A&B

I have data like ’xy23z4w7′ here I want to keep numbers. How to find out in V?

A. Purge char(.

B. Keep char(.

C. Char(.

D. Purge

I have data fields like Sales, CategoryName. To find out the sum of sales of average of CategoryName?

Avg (aggr (sum (sales., CategoryName..

I have fields like ProductID, CustomerID and Date. Which concept is useful to reduce the size of field values to create a single key of three fields in V?

A. AutoNumber ( ProductID&’|’&CustomerID&’|’&Date. as key

B. AutoNumber ( ProductID&’|,&CustomerID&’|’&Date. as key

C. AutoNumber ( ProductID&’|,&CustomerID, Date. as key

D. AutoNumber ( ProductID, CustomerID, Date. as key

How to drop a table in V?

Orders:

Load OrderID,

CustomerID,

Amount

From

[lib://Test1/orders.xls]

(biff, embedded labels, table is Orders$.;

A. DROP * Orders;

B. DROP table Orders;

C. DROP table into Orders;

D. DROP table Orders:

Left (‘xyzwabc’, 3.. What should be the result?

A. abc

B. xyz

C. xya

D. bca

How to display the current time?

Date (now (.,’hh:mm TT’.

Differentiate between Keep and Join.

Join merges two tables to create one table whereas Keep implements Join logic on two tables but maintain them separately.

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.

What is Fact Constellation Schema?

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.

What are delimited files and why are they called CSV files?

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.

How many types of charts are used in QlikView?

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.

What is the difference between dimensional and relational modeling?

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.

What is a circular reference, and how to avoid it?

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

What is the difference between the drill-down group (hierarchical groups ) and the cyclic group?

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.

What is the difference between V Publisher and V Server?

V Server is a program installed in a physical server with a number of CAL’s to authorize users to access V files on the server. V Publisher is a program that gives centralized control of all V files and how to schedule them.

What P(. and E(. in the Set analysis?

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.

Which tool is provided by V to get a snapshot view of your table?

Table Viewer is the tool provided by V that is used to get a snapshot of tables.

What type of data connections are used in QlikView?

OLEDB, ODBC, and SAP connectors.

What for macros are used in your application?

We can use macros for the following things-

To reload the application
To create objects.

What is the use of extended Interval Match function(.?

It is used for slowly changing dimensions.

What is the use of the Interval match function (.?

It is used to generate data buckets of different sizes.

What are the tasks and triggers in MC (QlikView Management Console.?

Tasks are generated to reload data, whereas triggers are created to schedule and run tasks at a certain time.

What is the QlikView server and Publisher?

QlikView Server hosts documents, users, and objects whereas QlikView Publisher is a component of VS which is responsible for data reduction and distribution, accessing, and managing content. Users need to get a separate license for Publisher.

What is the function of different tabs on the QlikView Management console?

There are three tabs present on the MC – 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.

What kind of Charts do we use in QlikView Admin?

We generally use a combo chart, scatter chart, bar chart, line chart, grid chart, etc.

How are the subset ratios and information density different from each other?

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.

What is Document-level Auditing in QlikView 11?

Document-level auditing helps administrators to effectively audit the user interactions and improve risk management and compliance.

What will you find in the menu bar of QlikView?

On the menu bar of QlikView, there are many menus available with the help of which we can adjust the properties, make changes, add new objects in the sheet etc. The options available in the menu bar are:

File
Edit
View
Selections
Layout
Settings
Bookmarks
Reports
Tools
Object
Window
Help

Can we load Web files into QlikView? If yes, how?

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. Selecting that option will ask for the URL of the web file and the file will be loaded.

What are the different types of data load?

There are seven different types of load in QlikView.

Load from files
Resident Load
Incremental Load
Inline Load
Add Load
Buffer Load
Binary Load

What are the types of files you can load data from?

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 vx files.

What is Incremental Load?

When in an already loaded table, only the new data values are updated or loaded without reloading the whole data table again, then it is termed as Incremental Load. In incremental loading, old data is taken from the stores QVD files and new data from the data sources and then new is added or updated in the old one.

What is Preceding Load?

When data is loaded using the bits of an already existing load statement then it is called Preceding load. First to be loaded in the original load statement followed by the load statement for the preceding load.

Explain Binary Load.

A binary load is the type of data loading when data is loaded from a QlikView file (qvw file. into the system’s RAM. The data from qvw file is loaded in 0s and 1s i.e. in binary. Binary load replicates the data structure and design into another qvw file.

What do you mean by Buffer load? How is it Significant?

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.

How are QVD files created?

A QVD file is created using a STORE command. It is created while the main data file is loaded into the script. However, the QlikView document or file will be saved separately with a .qvw extension and the QVD file will be saved at the location defined by you in the path with a .QVD extension.

Syntax: STORE<TableName>INTO<Path\FileName.QVD>

What are Sheets in QlikView?

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.

What are Sheet Objects? Name them.

Sheet Objects are the items that displays data in a certain way for the user. A dashboard is made using these sheet objects appropriately. There are many kinds of sheet objects available like,

List box
Statistics box
Multi-box
Table box
Chart
Input box
Current Selection box
Button
Text Object
Line/Arrow Object
Slider/Calendar Object
Bookmark Object
Search Object
Container

What are some major categories into which QlikView’s functions are divided?

Aggregation
Date and Time
Exponential and Logarithmic
Financial
General Numeric
Logical Function
Mapping Function
Number Interpretation
Range
String
Trigonometric and Hyperbolic

What is the difference between numsum(. and numcount(. functions?

The numsum function returns the sum of the numbers while the numcount function returns the total number of numeric values found. For example, if we have 2,4,5 as input, then numsum will return 11 and numcount will return 3.

What are the String functions? Name some of them.

String functions apply on a string input. Some of the most commonly used string functions are,

ord(s.
chr(n.
len(s.
capitalize(s.
evaluate(s.
left(.
right(.

What chart types do we use in QlikView Admin?

In QlikView Admin, we generally use bar charts, line charts, combo charts, scatter charts, grid charts, etc.

Explain Set Analysis in QlikView.

Mostly used in aggregated functions like sum (year., avg, max, min, etc., set analysis is used to define a set (or a group. of data values.

Define Trellis chart.

In the trellis chart, we can create an array of charts based on the first dimension. It is basically a grid of small charts or a repetition of charts. Bitmap charts can also be made up of the trellis display.

Explain Mini chart. What do you mean by sub-reports and how can you create them?

In QlikView, with the help of a mini chart, we can set the type of modes, instead of values, in the table mode. We can also set colors for the chart.

How many dimensions can you use in a Bar chart?

In a bar chart, we can use only two dimensions.

Which QlikView object has only expression and no dimension?

Gauge chart and list box have only expression and no dimension.

How can you use Macros in your application?

We can use macros for various purposes, such as reloading the application and creating an object.

What do you understand by layers in QlikView?

Layers are basically set on sheet object properties in the layout tab, where there are options such as Bottom, Top, and Normal, respective to the numbers −1, 0, and 1.

Explain Interval Match.

IntervalMatch prefixes with the load statement that is used for connecting different numeric values to one or more numeric intervals.

Explain the IntervalMatch(. function.

The IntervalMatch(. function is used to generate data buckets of different sizes.

What is a Container?

A container object is used to keep multiple charts. We can use a container object to keep many charts in the same box.

What do you understand by the extended IntervalMatch(. function?

The extended IntervalMatch(. function is used for Slowly Changing Dimensions.

What are the new features in V 11?

Container object, granular chart dimension control, actions like clear filed, metadata, etc. are some of the new features in V 11.

Explain Identifier’s syntax.

0: Represents an empty set
1: Represents full sets of records
$: Represents the record of the current selection
$1: Represents the previous selection
$_1: Represents the next selection
Bookmark01: Represents the Bookmark name

Explain the 3-tier architecture of QlikView Application.

Tier I: Raw data is loaded, and QVD is created
Tier II: QVD is converted in business login and the requirement of business and data model is created.
Tier III: Reading all QVD from Tier II, a single QVW is made.

How does QlikView store data internally?

QlikView stores data in QVD as QVD has data compression capability. QlikView has better performance than other BI tools because of its memory analytics approach.

Differentiate between Keep and Join.

Keep and Join do the same functions, but keep creates two tables whereas join merges two tables to create one table. Keep is used before the load or select statement.

Define Synthetic Key.

A synthetic key is the key used when two or more tables consist of more than one common column among them.

What is Incremental Load in QlikView Architect?

Incremental load is nothing but loading new or changed records from the database. With the help of QVD files, we can use incremental load.

Differentiate between the Set and Let options in QlikView.

Set: It assigns a variable to a value without assessing the expression.
Let: It assigns a variable to a value after assessing the expression.

Define QlikView Resident Load.

Resident load is a part of loading data in the QlikView application. It is used for loading the data in tables, which is already loaded in the QlikView application.

What is Concatenation?

Concatenation means a sequence of interconnected things, i.e., any columns or rows that are related to each other can be connected through concatenation.

Define NoConcatenation.

NoConcatenation prefix is used to force two identical tables as two separate internal tables.

Define the Connect statement.

The connect statement is used to establish a connection to the database with the help of an ODBC or an OLEDB interface.

What do you understand by Fact Constellation Schema?

Fact Constellation schema is a logical database structure of a data warehouse. It is designed with the help of a denormalized fact.

How can you handle Early Arriving Facts?

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.

What type of data do we use generally?

We use flat files, Excel files, QVDs, etc. as data.

Elucidate QlikView.

QlikView is the Business Intelligence tool used by the University of St Andrews. With QlikView, data from different university systems are combined and presented in a single dashboard in an easy and understandable way.

QlikView dashboards at the University of St Andrews are built on the following principles:

Dashboards must be effective to use.
Dashboards must support users in carrying out their tasks.
Dashboards must provide the right kind of functionality.
It should be easy to learn and remember how to use a dashboard.
To use QlikView, users need not have any technical expertise in information systems, but a willingness to learn would be good to have.

What is QlikView Comparative Analysis in the QlikView Developer platform?

Business users can quickly gain new insights when analyzing their information in QlikView, with its new comparative analysis options. QlikView app developers can now create multiple selection states in a QlikView app; they can create graphs, tables, or sheets based on different selection sets.

What mobile device platforms does QlikView 11 support?

QlikView 11 delivers mobile functionality for Apple iOS and Android tablets and smartphones. QlikView supports Android tablets when the following 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.

What are the main features of QlikView?

QlikView offers the following features:

Dynamic BI ecosystem
Data visualization
Interactivity with dynamic apps, dashboards, and analytics
Search across the entire data
Secure and real-time collaboration

What are the differences between QlikView Server editions?

QlikView Server Enterprise Edition (EE.is available to those wishing to support a large number of users and integrate into enterprise environments. It includes features such as:
- Unlimited documents
- Integration with third-party security systems
- Server clustering
QlikView Small Business Edition (SBE.is designed to be used in smaller deployments. It has the following limitations:
- Can only be used with Named and Document CALs
- Limited to 25 Name or User CALs
- Limited to 100 Document CALs
- No support for additional servers
- Only supports Windows Active Directory to handle security and access control
QlikView Information Access Server (IAS.is designed to power public Internet sites. This edition:
- Includes the add-on, QlikView Real-time Server
- Is licensed for an uncapped number of users but limited to one QlikView document
- Must only be set to the anonymous mode, and authentication must be set as ‘Off’
- Requires that the QlikView Server be on the public Internet
- Requires that the URL for accessing the site powered by the QlikView Server be publicly accessible
- Requires that no QlikView client (e.g., QlikView Desktop, Internet Explorer plug-in, Ajax, etc. can access the QlikView Server (all user interfaces must be built by the customer manually or with QlikView Workbench.
QlikView Extranet Server (ES.is designed to extend QlikView functionalities to external users via an extranet. ES:
- Requires authentication, i.e., users must be external to the purchasing organization (customers, partners, etc.
- Restricts server access to the Ajax client and mobile clients
- Provides the option to customize the QlikView application via the included QlikView Workbench
- Supports a maximum of three QlikView documents
- Supports session CALs and usage CALs only

So, this brings us to the end of the Qlik View Interview Questions blog. This Tecklearn ‘Top Qlik View Interview Questions and Answers’ helps you with commonly asked questions if you are looking out for a job in Qlik Vew or Business Intelligence Domain. If you wish to learn Qlik View and build a career in Business Intelligence domain, then check out our interactive, Qlik View Training, that comes with 24*7 support to guide you throughout your learning period.

https://www.tecklearn.com/course/qlik-view-certification-training/

QlikView Certification Training

About the course

Tecklearn’s QlikView Certification Training will help you become an expert in Data Visualization with QlikView. Learn all the basics and advanced features of QlikView such as data modelling, reports and dashboards, visualization, object formatting, system table etc. Along with this, you will be given hands-on working experience on real-time projects that will help you pass the QlikView certification exam. You also get hands-on experience in QlikView applications.

Why should you take QlikView Training?

The average annual pay for a QlikView Professional is $122,000. -PayScale.com.
Deloitte, Cisco, Qualcomm, Sony, AON & other top Fortune 500 companies use QlikView
QlikView – A Leader in 2017 Gartner Magic Quadrant for Business Intelligence & Analytics Platforms (For 7th Consecutive Year).

Curriculum

Introduction to QlikView

Concept of Business Intelligence
Features and components of QlikView
Comparison with other BI tools
Architecture
Installation & Navigation
QVS, QVW and .log files
Sheet Objects
Dimensions and Expressions
Various file types and extensions

Various QlikView Products

Overview of the various QlikView products

Introduction to Data and Scripting

Structuring the Script
Create tabs in the scripts, Debugging of scripts
Hands On

Data Model

QlikView Data File Types: QVD, QVX
System fields
Star schema
Synthetic Key Tables
Data Modelling Considerations
Straight and Pivot Table
Hands On

Components of Qlik View

Sheets and Sheet Objects
The List Box
The Table Box
The Multi Box
The Button & Text Object
Basic Charts
Hands On

Set Analysis

Set analysis
Working with modifiers, identifiers, operators, example of expressions,
Indirect set analysis
YTD & MTD

QlikView Functions, Reports and Charts

Uses of Expressions
Chart Properties: Dimensions
Qlikview Functions
Adhoc Reports
Incremental Load using QVD Files
Bookmarks
Hands On

Data Analysis

What-if Analysis
Comparative Analysis
Dynamic Reporting or Ad-hoc Reporting
Document Analyzer

Qlikview Security

QlikView security
Defining the access controls and levels of access
Maintaining the access control database

QlikView Administration

QMC (QlikView Management Console)
Server Installation & Deployment

QlikView Project

748