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

Looking at the above image:

What does it mean to you?


Options are :

  • QlikView Model - Extraction, Transformation and Load
  • QlikView Incremental Load
  • QlikView Semantic Databases
  • QlikView Generic Databases

Answer :QlikView Incremental Load

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:



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 :

  • /rp
  • /pl
  • /lp
  • /p

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

While debugging QlikView application...which of the following button(s) ends the debugging and closes the debugger window. All the data loaded until that point in the last debugging script execution remains loaded in the current QlikView application?


Options are :

  • End Here
  • Clear
  • Close
  • Cancel

Answer :End Here

Become a Certified QlikView Expert Set 6

What does the following ER diagram relationship mean to you?



Options are :

  • Many-to-Many
  • One-to-Many
  • Many-to-One
  • One-to-One

Answer :One-to-Many

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 :

  • Yes
  • No

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:


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 :

  • And
  • Like
  • Not
  • Xor
  • Or

Answer :Like

Become a Certified QlikView Expert Set 9

Correct the following script:


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?



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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions