Most frequently Asked QlikView Interview Questions

1. What is QlikView?
2. What are the unique features of QlikView?
3. What are the advantages QlikView?
4. What is Scripting?
5. What are the Aggregate Functions of QlikView?
6. Give an Example of Aggregate Functions?
7. What are Modifiers?
8. What do you comprehend by layers in Qlikview?
9. How can we Evaluating Variables in Load Script?
10. What is the best practise to avoid executing a huge intermediate query multiple times?
11. What are Sheets in QlikView?
12. What is authorization in QlikView?

What is QlikView?

QlikView is an intelligence tool used in converting raw data in to knowledge, and acts as a human brain which works on association and can go into any direction in searching the answers.

What are the unique features of QlikView?

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

What are the advantages QlikView?

Advantages of QlikView are as follows:
Data sharing
Data interpretation and analysis
Self-service tool
Low Maintenance
Data security
Direct and indirect search
Cheaper

What is Scripting?

Scripting helps in enabling the control of data load options and data transformations.It also enables the use of may inbuilt functions available in QlikView and helps in creating subroutines for using multiple scripts within QlikViewdocument.

What are the Aggregate Functions of QlikView?

QlikView Aggregate functions are used in producing aggregate data from the rows of the tables and are applied to the columns when we are creating the load script.
The functions of Aggregate Functions are:
SUM - helps in giving the sum of the numeric values of the column.
AVG - helps in giving the sum the average of the numeric values of the column.
MAX - helps in giving the sum the maximum of the numeric values of the column.
MIN - helps in giving the sum the minimum of the numeric values of the column.

Give an Example of Aggregate Functions?

Product_Line,Product_category,Quantity,Value
Sporting Goods,Outdoor Recreation,12,5642
Food, Beverages & Tobacco,38,2514
Apparel & Accessories,Clothing,54,2365
Apparel & Accessories,Costumes & Accessories,29,4487
Sporting Goods,Athletics,11,812
Health & Beauty,Personal Care,21,6912
Arts & Entertainment,Hobbies & Creative Arts,58,5201
Arts & Entertainment,Paintings,73,8451
Arts & Entertainment,Musical Instruments,41,1245
Hardware,Tool Accessories,2,456
Home & Garden,Bathroom Accessories,36,241
Food,Drinks,54,1247
Home & Garden,Lawn & Garden,29,5462
Office Supplies,Presentation Supplies,22,577
Hardware,Blocks,53,548
Baby & Toddler,Diapering,19,1247

What are Modifiers?

Modifiers helps in dealing with the Fields name.

sum({$<Region=>}Sales)

What do you comprehend by layers in Qlikview?

Layers are determined to the sheet objects 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.

How can we Evaluating Variables in Load Script?

Let v_myNumber = year(today());
Let v_myString = '2017-08';

If left($(v_myString),4) = text($(v_myNumber)) Then
    'do something
Else
    'do something else
End If;

What is the best practise to avoid executing a huge intermediate query multiple times?

LongQuery: SELECT * FROM LONGQUERY;
SmallQuery1: LOAD field1, field2 Resident LongQuery where A=1;
SmallQuery2: LOAD field1, field2 Resident LongQuery where B=1;
Drop Table LongQuery;

What are Sheets in QlikView?

Sheets helps in dividing QlikView documents into multiple sections, and will have at least one sheet in it, we can add more from the sheet Properties options.

What is authorization in QlikView?

Authorization helps in permitting the users in accessing the resources and are implemented at multiple levels like:
Document-level
Data level
Sheet Level
Chart level
Column level