Become a Certified QlikView Expert Set 1

Which of the following feature(s) are not limitations of Qlik Direct Discovery?

Options are :

A: Calculated Dimensions
C: Use of aggregation functions
D: Binary load from a QlikView document with a Direct Discovery table
B: Section Access

Answer :C: Use of aggregation functions

Become a Certified QlikView Expert Set 10

What is the result of the following expression in QlikView?

`=RangeMissingCount(2, '2', 'x', Null() )`

Options are :

Null
2
1
3

Answer :2

What is the result of the following line in the LOAD statement:

Temp:
LOAD 
    12/31/96 as Date
AutoGenerate 1;

Options are :

0.00403225806451613
'DD/MM/YY' - Dual representation of Date
Syntax Error
'DD/MM/YY' - String representation as Date

Answer :0.00403225806451613

Become a Certified QlikView Expert Set 2

What is the result of the expression:

`Mod(7.5, 2.5)`

in QlikView?

Options are :

Null
0
1
3

Answer :Null

What does QVW file contain?

Options are :

The data itself The script needed to update the QlikView file with new data from the data source Layout information, including all the sheets, list boxes, charts, etc. Meta File Document alerts, server bookmarks, document bookmarks and document reports Access restriction information Power Tools
The data itself The script needed to update the QlikView file with new data from the data source QVD File Layout information, including all the sheets, list boxes, charts, etc. Meta File Document alerts, server bookmarks, document bookmarks and document reports Access restriction information Macro module
The data itself The script needed to update the QlikView file with new data from the data source Layout information, including all the sheets, list boxes, charts, etc. Document alerts, document bookmarks and document reports Access restriction information Macro module

Answer :The data itself The script needed to update the QlikView file with new data from the data source Layout information, including all the sheets, list boxes, charts, etc. Document alerts, document bookmarks and document reports Access restriction information Macro module

What will happen if you clone a detached chart in QlikView?

Options are :

B: The cloned chart will also be detached
D: You can't clone a detached chart
C: Both the chars will be attached
A: The cloned chart will be attached

Answer :A: The cloned chart will be attached

Become a Certified QlikView Expert Set 3

Which of the following are the relational operators in QlikView?

Options are :

Answer :=

What does the "tt" symbol stand for while formatting in QlikView?

Options are :

AM/PM
Milliseconds
Time Stamp
Seconds

Answer :AM/PM

Which of the following is the default compression mode in Preferred Save Format?

Options are :

None
Medium
High
Low

Answer :High

Become a Certified QlikView Expert Set 4

Which of the following statement(s) is NOT true about QlikView CAL(s)?

Options are :

C: The CALs require the QlikView Servers within a cluster to be within the same geographical and physical location and within the same network
D: All of the above the statements are TRUE
A: CAL(s) cannot be transferred between different QlikView Server clusters
B: A CAL is never transferred to a client

Answer :D: All of the above the statements are TRUE

Which of the following command line syntax is used for partial reload and to close the document after saving?

Options are :

Answer :/rp

Which of the following element in Set Analysis is equivalent to a WHERE clause in SQL?

Options are :

Set Operator
Set Modifier
P() & E()
Set Identifier

Answer :Set Modifier

Become a Certified QlikView Expert Set 5

What is the range of "Order" cascade menu which controls the layers like (Bring to Front, Send to Back, Bring Forward & Send Backward)?

Options are :

-128 to 127
-127 to 127
-128 to 128
-127 to 128

Answer :-128 to 127

What is the result of the following expression in QlikView where vMyVariable is empty?

`SubField(vMyVariable, ';', 1)`

Options are :

0
Error Message
NULL
Empty String

Answer :Empty String

Which of the following expression provides: Date of last script execution?

Options are :

Today(0)
Today(1)
Today(2)
Today()

Answer :Today(0)

Which of the following statement is True about the print and export to Microsoft Excel functionality in QlikView?

Options are :

C: This functionality can be restricted at the document level for all the users on the server
D: This functionality can be restricted at the server level for all the user level (All or None)
B: This functionality can be restricted at the user level for all the document on the server
A: This functionality can be restricted at the user level for each document on the server

Answer :A: This functionality can be restricted at the user level for each document on the server

Become a Certified QlikView Expert Set 7

What does QAR stand for?

Options are :

QlikView Archive
QlikView Access Repository
QlikView Application Repository
QlikView Architecture

Answer :QlikView Archive

What does >> in QlikView mean to you?

Options are :

Set Operator
Greater than but not equal to
Set Modifier
Bit Operator
Relational Operator

Answer :Bit Operator

Can you use Concatenate statement with two Mapping Load tables with the same field names?

Options are :

Answer :No

Become a Certified QlikView Expert Set 8

Which of the following files contains Annotations in Qlik Architecture?

Options are :

QVD
.Meta
None of the above
.Shared

Answer :.Shared

Correct the following script:

Sales:
LOAD Account,
    'Land Name' as Country,
    Region,
    TransID,
    Amount,
    Quantity,
    TranDate   as   OrderDate
From Resident TempSales;

Options are :

Sales: LOAD Account, 'Land' as Country, Region, TransID, Amount, Quantity, TranDate as OrderDate Resident TempSales;
Sales: LOAD Account, 'Land Name' as Country, Region, TransID, Amount, Quantity, TranDate as OrderDate WHERE Resident TempSales;
Sales: LOAD Account, "Land Name" as Country, Region, TransID, Amount, Quantity, TranDate as OrderDate Resident TempSales;
Sales: LOAD Account, Land Name as Country, Region, TransID, Amount, Quantity, TranDate as OrderDate Resident Sales;

Answer :Sales: LOAD Account, "Land Name" as Country, Region, TransID, Amount, Quantity, TranDate as OrderDate Resident TempSales;

Which of the following is NOT a logical operator in QlikView?

Options are :

Answer :Like

Become a Certified QlikView Expert Set 9

Correct the following script:

Sales:
LOAD ID, 
     ProductCategory, 
     SaleAmount
FROM
[C:\Qlikview\data\product_lists.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
 
LEFT JOIN(product_lists)
 
LOAD ProductID, 
     ProductCategory
FROM
[C:\Qlikview\data\Productsales.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Options are :

Sales: LOAD ID as ProductID, ProductCategory, SaleAmount FROM [C:\Qlikview\data\product_lists.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); LEFT JOIN(product_lists) LOAD ProductID, ProductCategory FROM [C:\Qlikview\data\Productsales.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Sales: LOAD ID, ProductCategory, SaleAmount FROM [C:\Qlikview\data\product_lists.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); LEFT JOIN(Sales) LOAD ProductID, ProductCategory FROM [C:\Qlikview\data\Productsales.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Sales: LOAD ID as ProductID, ProductCategory, SaleAmount FROM [C:\Qlikview\data\product_lists.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); LEFT JOIN(Sales) LOAD ProductID, ProductCategory FROM [C:\Qlikview\data\Productsales.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Answer :Sales: LOAD ID as ProductID, ProductCategory, SaleAmount FROM [C:\Qlikview\data\product_lists.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); LEFT JOIN(Sales) LOAD ProductID, ProductCategory FROM [C:\Qlikview\data\Productsales.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Reading the following script. What kind of data model does the script generate?

LOAD ProductID, 
     ProductCategory, 
     ProductName
FROM
[C:\Qlikview\images\StarSchema\Product_dimension.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
 
LOAD TimeID, 
     Year, 
     Month
FROM
[C:\Qlikview\images\StarSchema\Time.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
 
LOAD SupplierID, 
     SupplierName
FROM
[C:\Qlikview\images\StarSchema\Suppliers.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
 
LOAD RegionID, 
     Continent, 
     Country
FROM
[C:\Qlikview\images\StarSchema\Regions.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
 
LOAD ProductID, 
     RegionID, 
     TimeID, 
     SupplierID, 
     Quantity, 
     DefectPercentage
FROM
[C:\Qlikview\images\StarSchema\Supplier_quantity.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Options are :

Star Schema
Snowflake Schema
Circular Reference
Mixed Schema

Answer :Star Schema

When modifying the script.js file of an extension object, how can you see the changes made in the QlikView Client?

Options are :

Refresh the Webpage
Reload the QlikView Script
ALL of the above
Re-add the Extension object

Answer :Refresh the Webpage

What is the colour of Excluded values which are selected?

Options are :

Blue
Grey
None of the above
White

Answer :None of the above

Comparing QlikView associative join with SQL joins... what does it resemble?

Options are :

Left Join
Inner Join
Outer Join
Right Join

Answer :Outer Join

For a typical LOAD or SELECT statement the order of events is roughly as follows:

Options are :

Evaluation of expressions Renaming of fields by as Renaming of fields by alias Qualification of field names Mapping of data if field name matches Storing data in an internal table
Qualification of field names Evaluation of expressions Renaming of fields by as Renaming of fields by alias Mapping of data if field name matches Storing data in an internal table
Evaluation of expressions Qualification of field names Mapping of data if field name matches Renaming of fields by as Renaming of fields by alias Storing data in an internal table
Evaluation of expressions Qualification of field names Renaming of fields by as Renaming of fields by alias Mapping of data if field name matches Storing data in an internal table

Answer :Evaluation of expressions Renaming of fields by as Renaming of fields by alias Qualification of field names Mapping of data if field name matches Storing data in an internal table

What is the result of:

`Mid('QlikView', 5,8)`

Please don't try before answering the question.

Options are :

NULL
View
QlikView
iew

Answer :View

Which of the following statement is TRUE about QlikView when using Star Schema?

Options are :

D. All of the above are true
B. QlikView always take a large schema and queries a subset of tables
A. Selection in a QlikView document affects the entire schema
C. QlikView query result sets are independent of each other

Answer :A. Selection in a QlikView document affects the entire schema

Become a Certified QlikView Expert Set 3

Which of the following statement is NOT True about License Leasing in QlikView?

Options are :

Each time QlikView is started, QlikView tries to contact the QlikView Server to renew the license lease.
A license lease is possible using the QlikView Desktop.
If the client cannot reach the Server after 21 days, the license lease expires.
The QlikView client must be authenticated user.

Answer : If the client cannot reach the Server after 21 days, the license lease expires.

Input fields are introduced in which version of QlikView?

Options are :

QlikView 9
QlikView 8
QlikView 7
QlikView 10

Answer :QlikView 8

Become a Certified QlikView Expert Set 4

Which of the following statement(s) are FALSE about Table Viewer?

Options are :

Internal Table view is the default option in Table Viewer
Data preview is available in both the views (Internal Table & Source Table)
Internal Table view shows Synthetic Keys and Key Fields
Source Table view shows Synthetic Keys and Key Fields

Answer :Source Table view shows Synthetic Keys and Key Fields

What is the limit on number of dollar expansion can be calculated?

Options are :

1024
10
100
1000

Answer :1000

Which language is NOT supported by QlikView to build the Extension Objects?

Options are :

All of the above
Flash
Silverlight
Java

Answer :All of the above

Become a Certified QlikView Expert Set 5

You are running on 64-bit Windows & 64-bit QlikView. If you use Connect32 statement for ODBC in the script, what is the result of this connection?

Options are :

D: There is no 'Connect32' statement in QlikView. We can only use Connect statement.
C: QlikView uses a 32-bit ODBC
B: QlikView uses a 64-bit ODBC because both (Windows & QlikView are running on 64-bit)
A: Causes script error because you can't use `Connect32` statement on 64-bit Windows & QlikView

Answer :C: QlikView uses a 32-bit ODBC

Which of the following statement(s) are TRUE about "Sample" prefix Load/Select statement in QlikView?

Options are :

Loads specific number of random records
Loads only first row from the table as sample data
Loads specific percentage of random records from the table
Loads random records based on probability for a given record to be read

Answer :Loads random records based on probability for a given record to be read

Where do you use/see "Global Grouping Mode" in QlikView?

Options are :

`Global Grouping Mode` is document level setting while using `Total` Qualifier in QlikView Expressions
Document Properties > Groups > Group Settings
`Global Grouping Mode` is used in the QlikView script while using `Groupby` clause
Dimension Limits Tab

Answer :Dimension Limits Tab

Become a Certified QlikView Expert Set 6

Which of the following dimension group is suitable for the following fields:
Country, SalesPerson, BusinessCode

Options are :

Circular group
Cyclic group
Drill down group
Hierarchy group

Answer :Cyclic group

What is the threshold time for "Sleep" script statement in QlikView?

Options are :

30 Mins
6 Mins
3 Mins
1 Hour

Answer :1 Hour

What is the use of GetObjectField() function in QlikView?

Options are :

It returns the Dimension Name in the Chart Object
It returns the Field Name in the Table
This function doesn't exist. This is just a trick question.
It returns the Object ID for current Chart Object

Answer :It returns the Dimension Name in the Chart Object

What is the color of Forced Excluded cell?

Options are :

Blue
Gray
Black
Red
Yellow

Answer :Red

Which of the following QlikView chart is appropriate to show the composition element?

Options are :

Gauge Chart
Line Chart
Bar Chart
Pie Chart
Scatter Chart

Answer :Pie Chart

Which of the following function doesn't count records excluded by where clause while executing the Load Script?

Options are :

AutoNumberHash128()
AutoNumber()
RowNo()
RecNo()
IterNo()

Answer :RowNo()

Which of the following command line syntax is used for partial reload and to keep the document open without saving?

Options are :

Answer :/lp

What is the use of third parameter in Crosstable prefix?

Options are :

B: To specify number of qualifying columns.
A: To specify sort order in the output table.
D: This is trick question! there is no third parameter.
C: To specify number of rows in the output table.

Answer :B: To specify number of qualifying columns.

Is there a global setting in QlikView to override conditional show/hide property?

Options are :

FALSE
TRUE
Don't Know

Answer :TRUE

While making Pseudo-URL connection... Internet explorer 7 and 8 do not support @ to prevent URL spoofing. Which of the following character do you use?

Options are :

None of the above
%@A
%40
%3A
%4A

Answer :%40

What is the use of "Force" statement in QlikView Load Script?

Options are :

A: Used for forced concatenation of the tables
C: Used to create forced associations of fields while using Dual()
D: Used to convert NULL values to forced text strings
B: Used to interpret field values with upper | lower | mixed conventions

Answer :B: Used to interpret field values with upper | lower | mixed conventions

Following expression results syntax error. Please, choose ONE correct expression:

`=Sum(1{<Product = {'Bottle'} + Customer = {'Charlie'} >} Sales)`

Options are :

=Sum(1{} Sales)
=Sum(1{ + } Sales)
=Sum({1} Sales)
=Sum({1 + } Sales)

Answer :=Sum({1 + } Sales)

Options are :

Actions
Section Access
On-Open Triggers
Set Analysis

Answer :Section Access

You are trying to reload your colleagues script and it gives script error. How do you fix this issue?

Films:
LOAD
 *,
 Rating as RatingSquare,
 Rating as RatingStar,  
 if(Rating = 5, RGB(103, 167, 202), 
 if(Rating = 4, RGB(140, 191, 218),
 if(Rating = 3, RGB(175, 212, 230),
 if(Rating = 2, RGB(186, 218, 233),
 if(Rating = 1, RGB(232, 241, 246),
 RGB(205, 205, 205)))))) as RatingColor
 ;
 
LOAD
 FilmID, 
     Title, 
     Year,
     Ceil(Rating/2) as Rating,    
// 1 as FilmCount,     
     Length, 
     if([Year] > 1,right([Year] - mod([Year], 10), 4) & chr(39) & 's') as Decade
FROM
[..\Database\Films Database.xls]
(biff, embedded labels, table is Films$);
 
FilmCount:
LOAD DISTINCT
 Title,
 1 as FilmCount
FROM RESIDENT Films;
 
Actors:
LOAD FilmID, 
     Actor
FROM
[..\Database\Films Database.xls]
(biff, embedded labels, table is Actors$);

Options are :

Ceil() function has missing parameters
Remove "Distinct" in Resident Load
Remove "From" in Resident Load
Left Join Actors Table to remove synthetic keys/table

Answer :Remove "From" in Resident Load

When displaying data in a bar chart with how do you visually show totals as a single separate bar?

Options are :

In the Expression tab of the charts properties ensure 'Expression Total' is selected
Add an expression "=Sum(Total Value)"
In the Dimension Limits tab of the charts properties ensure 'Show Total' is checked

Answer :In the Dimension Limits tab of the charts properties ensure 'Show Total' is checked

Which of the following QlikView script statement(s) will be disregarded while using normal reload (CTRL + R)?

Options are :

Replace Partial Load * from Table1.csv;
Replace Only Load * from Table1.csv;
Replace Load * from Table1.csv;
Partial Only Load * from Table1.csv;

Answer :Replace Only Load * from Table1.csv;

Become a Certified QlikView Expert Set 1

Which of the following is NOT a Sheet Object in QlikView?

Options are :

Current Selection Box
Bookmark Object
Variable Object
Custom Object

Answer :Variable Object

How to recover/undo scrambled data in QlikView?

Options are :

Reload the QlikView application
We can never unscramble once the data is scrambled
Qlik Support can Unscramble the data
Admins can use Unscramble option

Answer :Reload the QlikView application

Which of the following statement is NOT True about Binary Load?

Options are :

Binary Load does inherit Section Access from the source QVW file
Binary Load does inherit/bring the objects into destination QVW file
Binary Load doesn't load the Variables

Answer :Binary Load does inherit/bring the objects into destination QVW file

Become a Certified QlikView Expert Set 10

What are the standard QlikView colours?

Options are :

Green, Grey and White
Green, Grey, White and Blue
Green, Grey, White, Blue and Red
Green & Grey

Answer :Green, Grey, White, Blue and Red

You have been asked to create a report in QlikView and email the report in PDF to regional sales teams. Each page should show sales trending for each regionalsales team. What will you do to develop the report?

Options are :

It is not possible to create separate report for each regional sales team as QlikView is not a static reporting tool.
Create a bookmark for each regional sales team and use bookmark to create PDF report for distribution
Create one report with banding on regional sales team
Create one report for each Regional Sales team using WHERE clause and distribute via Loop and Reduce

Answer :Create one report with banding on regional sales team

What is meaning of this Set Analysis expression?
sum({<[Customer Region] = {"*"}>} LineSalesAmount)

Options are :

This is invalid syntax as * is not allowed in the element list
Sales for All Customer Regions
Sales for All Non Null Customer Regions
This is invalid syntax as * should be enclosed in a single quote.

Answer :Sales for All Non Null Customer Regions

What does ErrorMode = 3 denote?

Options are :

QlikView will trigger a `Execution of script failed…` error message
QlikView script execution will halt and the user will be prompted for action
ErrorMode 3 doesn't exist
QlikView will simply ignore the failure and continue script execution at the next script statement

Answer :ErrorMode 3 doesn't exist

Become a Certified QlikView Expert Set 3

Which of the following statement(s) are FALSE about SQLValue function in QlikView?

Options are :

This function is part of Direct Discovery feature in QlikView 11
SQLValue function accepts ODBC or OLEDB data sources and executes Select statement
This function returns scalar value from external database
All of the above are False

Answer :This function is part of Direct Discovery feature in QlikView 11

What is the difference between BITXOR and BITOR Operators?

Options are :

BITOR returns only logical exclusive values compared to BITXOR
BITXOR returns only logical exclusive values compared to BITOR
Both of the them provide same result
BITOR was part of QlikView 10 and BITXOR was introduced in QlikView 11

Answer :BITXOR returns only logical exclusive values compared to BITOR

What does " / " represent in Set Operations?

Options are :

Quotient
Symmetric Difference
Divisor
Exclusion

Answer :Symmetric Difference

Become a Certified QlikView Expert Set 4

What happens when "Prohibit Binary Load" option is enabled?

Options are :

Binary load is prohibited on documents without Section Access
We can't use this document to perform binary load in another document
We can't perform binary load in the current document
Binary load is prohibited on documents with Section Access

Answer :We can't use this document to perform binary load in another document

Which of the following chart(s) don't support Dimension Limits functionality in QlikView?

(Please don't check before answering the question)

Options are :

Radar Chart
Pivot Table
Funnel Chart
Straight Table
Mekko Chart

Answer :Pivot Table

What does $_1 represent in the Set Expression?

Options are :

Set Operator
Set Modifier
Set Dollar Expansion
Set Identifier

Answer :Set Identifier

Become a Certified QlikView Expert Set 6

What does "CalcTime" represent under Document Properties > Sheets tab?

Options are :

Cumulative calculation time in seconds after the last reload
Last recalculation time in seconds
Calculation time in milliseconds after the last user selection
Cumulative Calculation time in milliseconds after the last reload
Last recalculation time in milliseconds

Answer :Last recalculation time in milliseconds

Which of the following expression(s) return True?

Options are :

A: IF(NULL(), TRUE(), FALSE())
C: IF(TRUE(), TRUE(), NULL())
D: Trick question...all of the above functions return False
B: IF(TRUE(), NULL(), TRUE())

Answer :C: IF(TRUE(), TRUE(), NULL())

Which of the following is not a valid QlikView Colour functions?

Options are :

QlikTechBlue()
QlikTechGray()
QlikTechGreen()
Color(19)
Syscolor(1)

Answer :QlikTechGreen()

Become a Certified QlikView Expert Set 7

You implemented Section Access in your application but it is not working as all users can access all data. What is possibly wrong?

Options are :

USERID and PASSWORD fields and values are not in uppercase
"Initial data reduction based on Section Access" option in the opening tab of document properties is unchecked
Section Access script is not a hidden script
"Initial Section based on Section Access" option in the opening tab of the document properties is unchecked

Answer :"Initial data reduction based on Section Access" option in the opening tab of document properties is unchecked

Which of the following drivers/connectors are used to connect to Non-relationship databases like hierarchical data?

Options are :

All of the above
QDBC
ODBC
OLE DB

Answer :OLE DB

Become a Certified QlikView Expert Set 1