NEW
Font size
WorksheetsQlik View Quiz 3
Total questions: 35
Worksheet time: 18mins
What will be the output of the following expression: div(-4,-3)
-1
1
0
NULL
Which of the following objects does not support action?
Text Object
Button
Slider/Calendar Object
Line/Arrow Object
Which chart is ideal for one dimension with multiple measurements?
Pie Chart
Pivot Table
Straight Table
Grid Chart
Which sheet object is ideal for displaying explanatory text or pictures or for creating multi-colored sheet areas?
List Box
Multi Box
Text Object
Bar Chart
Which of the following expression when used as a part of the field list in a load or select statement, the text string “India” will be loaded as field value into the QlikView field “Country”?
'India' as Country
'Country' as India
'Indian Country'
Country of India
How many times the following script executes the Load statement :
FOR Each a in 1,3,7,’xyz’
LOAD *
FROM file$(a).csv;
NEXT
1
2
3
4
Consider the following expression :
Let T=now( );
What will be value for $(T) ?
Value of Current Time
Value of Current Date
now()
Error
Comparing QlikView associative join with SQL joins …
What does it resemble?
Outer Join
Left Join
Right Join
Inner Join
Which of the following is not true about Inline tables in Qlik View?
Used to create tables that do not reside in any of your data sources
Inline tables can be manipulated or changed by Enterprise users outside the application
Sorting dates uses inline tables
If used within an application, they can only be manipulated/changed by the Enterprise user
Which of the following can be classified as good aesthetics while designing the Qlik View app?
Dark Colors
Inconsistent Object Placement
Object Placed Off the Screen
Uncluttered
Which of the following function assumes implicit DISTINCT qualifier?
FirstSortedValue()
Aggr()
Count()
Concat()
When does the mapping table gets dropped?
At the end of the script execution.
After the ApplyMap function is used.
Immediately after the next Load statement where mapping table is used.
Whenever Drop Table is used.
For time dimension across quarters, what is the best visualization?
Line Chart
Bar Chart
Spider Chart
Box Chart
What is the answer to this set analysis:
sum( {1-$} Sales )
Returns Sales for the current selection.
Returns Sales of the previous selection.
Returns Sales of everything excluded by the current selection.
Returns total sales within the application.
How to create a QVD file?
STORE <Name of table> INTO <Path\FileName.qvd>
STORE <Name of table> FROM <Path\FileName.qvd>
STORE QVD <Name of table> INTO <Path\FileName.qvd>
STORE <Name of table> INTO <Path\FileName.qvs> QVD
This is defined as a table of summary that is a table that allows you to extract the information from a large data set.
Pivot Chart
Trellis Chart
Pie Chart
Straight Table
The QlikView Object that only has expression but no dimensions
Gauge Chart
Pivot Chart
Pie Chart
Bar Chart
This layout property has the options like TOP, BOTTOM, and NORMAL
Layers
Borders
Corners
Scrollbars
THis is a text file in which the data field values and data fields are separated by a semicolon, tabs, comma, etc.
Delimited Files
QVD Files
QlikView Files
Datasource Files
It is a type of LOAD where the file or table is already loaded and residing in the memory of QlikView.
Resident
Buffer
Add
Inline
It is a collection of tables having data created in QlikView. It can be easily read or written in QlikView
QVD
CSV
QVW
QDF
Which statement is accurate pertaining to Match() function:
A) Match() and Wildmatch() are Match() function
B) Match() and PickMatch() are Match() function
C) Pick() and Match() are Match() function
D) Match() and FuzzyMatch() are Match() function
A is TRUE and C is FALSE
B and C are TRUE
BOTH A and D are FALSE
A and D are TRUE
This QlikView script statement is used to load data from all files.
LOAD
SELECT
CONCATENATE
JOIN
This QlikView script statement is used to load from OLE DB or ODBC sources
LOAD
SELECT
CONCATENATE
JOIN
These keys are used when two or more tables contain more than one common column among them.
Synthetic Keys
Primary Key
Foreign Key
Linking Key
This is a sequence of interconnected things.
LOAD
SELECT
CONCATENATION
JOIN
These are features of QlikView EXCEPT:
The data connection is maintained automatically.
Qlikview data is stored in memory for multiple users to offer a super-fast user experience.
Transparent reporting and Scalability with Data Integration.
Various forms of data presentation.
These are features of QlikView EXCEPT:
Fast implementation
Common data discovery & local search
Secure working environment
Visual analytics & in-direct searches
These are QlikView Data and Time Functions EXCEPT:
localtime()
sysdate()
month()
Today()
These are QlikView Data and Time Functions EXCEPT:
makedate()
year()
CreateDate()
week()
These are QlikView Data and Time Functions EXCEPT:
timezone()
year()
GMT()
UTC()
These are the various types of QlikView Table EXCEPT:
Pivot Table
Cross Table
Mapping Table
System Table
These are the various types of QlikView Table EXCEPT:
Straight Table
Cross Table
Mapping Table
Statistics Table
This option in QlikView will assign a variable to value only after assigning the expression.
LET
SET
GET
FETCH
This option in QlikView will assign a variable to value without assessing any expression
LET
SET
GET
FETCH
