Most frequently Asked QlikView Interview Questions
- What is QlikView?
- What are the unique features of QlikView?
- What are the advantages QlikView?
- What is Scripting?
- What are the Aggregate Functions of QlikView?
- Give an Example of Aggregate Functions?
- What are Modifiers?
- What do you comprehend by layers in Qlikview?
- How can we Evaluating Variables in Load Script?
- What is the best practise to avoid executing a huge intermediate query multiple times?
- What are Sheets in QlikView?
- 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 interpretation and analysis
Direct and indirect search
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.
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: