Become a Certified QlikView Expert Set 9

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)

Considering the ER Diagrams. What does the following diagram represent?



Options are :

  • One A is associated with one or more B
  • One or many A is associated with one or more B
  • One A is associated with zero or more B
  • One or many A is associated with one B
  • One or many A is associated with zero or more B

Answer :One A is associated with zero or more B

What is "Strict Exclusion" related to?




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?


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

How many syntax errors are in this script?



Options are :

  • 2
  • 3
  • 5
  • 6

Answer :3

Become a Certified QlikView Expert Set 2

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

What will be list of values in the Quantity field?



Options are :

  • 200,15,300,15,200,22
  • 100,5,100,10,300,15.200,10,100,12
  • 100, 100, 300, 200, 100
  • 100,200,300

Answer :100,200,300

What do the following icons mean?


Options are :

  • Move one cell up and Refresh the app respectively
  • Previous Selection and Refresh the app
  • Drill down Group and Cyclic Group respectively
  • Dimension Group and Measure Group

Answer :Drill down Group and Cyclic Group respectively

Become a Certified QlikView Expert Set 5

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

Define the following data model?



Options are :

  • Link Table Schema
  • Dimensional Schema
  • Snowflake Schema

Answer :Link Table Schema

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

What is the correct ApplyMap statement?



Options are :

  • Subfield(ApplyMap('MAP_COUNTRIES',CountryData,Null()),'|',1) as CountryName2, Subfield(ApplyMap('MAP_COUNTRIES',CountryData,Null()),'|',2) as CountryCurrency2
  • Script will error our since the key field name between the target table and mapping table are not the same
  • mid(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',1) as CountryName2, mid(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',2) as CountryCurrency2
  • Subfield(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',1) as CountryName2, Subfield(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',2) as CountryCurrency2
  • You can't use concatenated key in the mapping table

Answer :Subfield(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',1) as CountryName2, Subfield(ApplyMap('MAP_COUNTRIES',CusCountry,Null()),'|',2) as CountryCurrency2

How will you show % value in the legend of a donut pie chart?




Options are :

  • In the presentation menu, select legend and under settings select "Show numbers in legend" option
  • In expression tab, select relative option to show %
  • In the number tab, select fixed number with two decimals and also check "Show in %" option
  • In the presentation menu, select 'Show numbers in legend" menu

Answer :In the presentation menu, select 'Show numbers in legend" menu

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions