Become a Certified QlikView Expert Set 10

If the pivot table and Year field are in the default state and Country and SalesPersons fields in 'Group 1' state, how will you write a Set Analysis expression that allows selection on the fields in 'Group 1' state to influence data in the pivot table?



Options are :

  • sum({[Group 1]} LineSalesAmount)
  • sum({[Group 1]} LineSalesAmount)
  • sum({} LineSalesAmount)
  • sum({} LineSalesAmount)

Answer :sum({[Group 1]} LineSalesAmount)

Following pivot table is not rendering accurate data. As highlighted, Anio Shoes has sales for months of Feb-July but the table shows null values.

What is the root cause of this issue?

Pivot chart dimension: Product name and Month

Pivot chart expression: avg(aggr(sum(LineSalesAmount), ProductName, Year))





Options are :

  • Developer needs to change aggregation function from avg to sum since avg will be shown only for one month and other months thus will get NULL values
  • Aggr function dimension has to be at a finer grain than the chart dimension
  • In the dimension tab of the chart, developer forgot to check "Suppress when value is NULL" option

Answer :Aggr function dimension has to be at a finer grain than the chart dimension

Become a Certified QlikView Expert Set 2

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

    What happens first when following script reloads?



    Options are :

    • Order by
    • If statement with peek and previous functions to create field [# Delta Units in Stock] gets evaluated
    • If statement with peek and previous functions to create field [# Delta Cumulative Units in Stock] gets evaluated

    Answer :Order by

    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

    What's most efficient way to transform table as depicted below?




    Options are :

    • Use Pivot table and swap rows and columns
    • Use load statement with Where clause for each field value and then concatenate these tables
    • Use Generic prefix
    • Use Crosstable prefix

    Answer :Use Generic prefix

    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 syntax for the ApplyMap function on the target table with a field DivID?



    Options are :

    • applymap ('Divisions_Map', DivisionID , 'Other') as [Division Name]
    • applymap ('Divisions_Map', DivID , 'Other') as [Division Name]
    • applymap (Divisions_Map, DivID , 'Other') as [Division Name]
    • applymap ('Divisions_Map', 'DivisionID' , 'Other') as [Division Name]
    • applymap ('Divisions_Map', 'DivID' , 'Other') as [Division Name]

    Answer :applymap ('Divisions_Map', DivID , 'Other') as [Division Name]

    Become a Certified QlikView Expert Set 7

    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

    One of your junior developers added Qualify statement to resolve a synthetic key but now the table has become an island table. How will you help him to associate the table with other tables?

    The script:




    Options are :

    • Add Unqualify SupplierID right after Qualify * statement
    • Add Unqualify %Key_dataroot_72A09EACE72FB6DB after Qualify * statement
    • Add Unqualify SupplierID and remove Unqualify * at the end of the load statement
    • Add Unqualify %Key_dataroot_72A09EACE72FB6DB at the end of the load statement

    Answer :Add Unqualify SupplierID right after Qualify * statement

    Become a Certified QlikView Expert Set 8

    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

    What is the correct Set Analysis expression for the highlighted column based on the user selection on field OrderID?



    Options are :

    • sum({} Quantity)
    • sum({} Quantity)
    • sum({} Quantity)
    • sum({} Quantity)

    Answer :sum({} Quantity)

    Become a Certified QlikView Expert Set 9

    What will happen when you reload this script?



    Options are :

    • Budget table will have 3 fields: %BudgetKey, BudgetYear, BudgetAmount
    • Script will error out as preceding load is not allowed with crosstable prefix
    • Script will run but it will produce a table with these fields: 2008, 2009, 2010, 2011, 2012
    • Budget table will have Five fields: Office, EmployeeID, BudgetYear, BudgetAmount, %BudgetKey

    Answer :Script will run but it will produce a table with these fields: 2008, 2009, 2010, 2011, 2012

    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 :

    • /rp
    • /pl
    • /pr
    • /lp

    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

    Comment / Suggestion Section
    Point our Mistakes and Post Your Suggestions