Become a Certified QlikView Expert Set 3

On a QlikView straight table, with one Dimension as [Region] with possible values:

{North, South, East, West} 

What do you categorize the following Expression as?

= [Region] = 'North' 


Options are :

  • Conditional Expression returning Boolean Value
  • Assignment Expression
  • Invalid Conditional Expression as there is no `IF` statement
  • Set Expression

Answer :Conditional Expression returning Boolean Value

Which of the following tasks create a temporary bookmarks on the server?


Options are :

  • Mail with bookmark as a link
  • Any bookmark created with alternate states
  • Sharing bookmarks
  • Including input field values while creating a bookmark

Answer :Mail with bookmark as a link

What is the result of the following expression? 

= Div(-4, -3)  

*Please don't try before answering the question.


Options are :

  • 1
  • -1
  • 0
  • NULL

Answer :1

Become a Certified QlikView Expert Set 4

What is "D" & "F" on the QlikView desktop status bar?




Options are :

  • Distinct and Fields
  • Dimension and Frequency
  • Dimension and Fields
  • Distinct and Frequency

Answer :Distinct and Frequency

Why is this load script not showing distinct values?

Result:



Options are :

  • DISTINCT keyword has to be placed in the preceding load statement instead of in the INLINE load statement
  • DISTINCT keyword should be placed after *
  • DISTINCT keyword is not allowed with INLINE load statement
  • DISTINCT keyword has to be placed after keyword INLINE

Answer :DISTINCT keyword has to be placed in the preceding load statement instead of in the INLINE load statement

Which of the following is the deterministic function in QlikView?


Options are :

  • None of the them
  • Autonumber()
  • Rand()
  • Hash128()

Answer :Hash128()

Become a Certified QlikView Expert Set 5

You created a variable, vMargin,  using variable expression editor but it shows same value in the table as shown below  as you are using dollar-sign expansion in the expression. How will you fix this?



Options are :

  • Add TOTAL qualifier to the sum(LineSalesAmount) expression in variable definition
  • Check source data
  • Add TOTAL qualifier to the sum(LineSalesAmount) expression in variable definition
  • Don't use dollar-sign expansion
  • Remove the = sign from the vMargin definition

Answer :Remove the = sign from the vMargin definition

Choose correct expression to display company name with highest sales amount in a text object.



Options are :

  • =FirstSortedValue(aggr(sum(LineSalesAmount), CompanyName). -CompanyName)
  • =FirstSortedValue(aggr(sum(LineSalesAmount), CompanyName). CompanyName)
  • =FirstSortedValue(CompanyName, aggr(sum(LineSalesAmount), CompanyName))
  • =FirstSortedValue(CompanyName, -aggr(sum(LineSalesAmount), CompanyName))

Answer :=FirstSortedValue(CompanyName, -aggr(sum(LineSalesAmount), CompanyName))

When does the mapping table gets dropped?


Options are :

  • Whenever Drop Table is used
  • Immediately after the next Load statement where mapping table is used
  • After ApplyMap function is used
  • At the end of the script execution

Answer :At the end of the script execution

Become a Certified QlikView Expert Set 6

What happens when you select "Country" on a chart object which has a missing node in the drill down group/hierarchy?Example:- 

Drill down group fields: 

{Region, Country, State, City} 

Field values: 

{Europe, England, NULL, London} 


Options are :

  • Can't create a group with a missing node (i.e. with NULL value)
  • QlikView shows a message about the missing node (i.e. State)
  • Nothing happens when you click on the chart because of the NULL value
  • QlikView jumps directly to City (i.e. London)

Answer :QlikView jumps directly to City (i.e. London)

Pressing Back or Forward buttons while using Alternate States affect...?


Options are :

  • Default State
  • Named State and Default State
  • Inherited State
  • All States

Answer :All States

What happens when you have duplicate values in Sort Weight field while using FirstSortedValue?


Options are :

  • Returns all the Values
  • Returns NULL
  • Returns First Value of Duplicates
  • Returns Last Value of Duplicates

Answer :Returns NULL

Become a Certified QlikView Expert Set 7

What is the result of the following expression in QlikView:

= Floor( 3.51 , -0.5 ) 

* Please don't try before answering the question.


Options are :

  • -4
  • 3
  • 4
  • NULL because Floor() function doesn't take the negative offset value
  • 3.5

Answer :4

A junior developer needs your help as he performed a binary load to import data model from another qvw but the reload fails with following error. 


His script syntax seems to be correct


What will you suggest him to fix this error?


Options are :

  • Remove square brackets from the binary statement
  • Binary load statement has to be on the first line of the script so move it from line 13 to line 1
  • Replace binary with binary load
  • File path has to be enclosed in single quotes

Answer :Binary load statement has to be on the first line of the script so move it from line 13 to line 1

Which of the following bookmark type(s) are NOT shown in Qlikview Management Console?


Options are :

  • Non-shared Personal Server Bookmarks
  • All Document Bookmarks
  • Shared Temporary Bookmarks
  • Non-Shared Temporary Bookmarks

Answer :All Document Bookmarks

Become a Certified QlikView Expert Set 8

What will happen when two (or more) reductions are mutually exclusive in Section Access Reduction without using “Strict Exclusion”?  

Example: 

AMERICAS,ENGLAND  

(Obvious that England doesn't belong to AMERICAS Region)


Options are :

  • QlikView will refuse to open the application
  • It works without any issue and user will ONLY see restricted data
  • Doesn't work in Access Point but it works on QlikView Desktop
  • Users will see full data

Answer :Users will see full data

Assume we have a field "MyString" with a single value: 

Row 1 | Row 2 | Row 3 | Row 4 | Row 5

What is the result of the following expression in the QlikView Load Script:

SubField (MyString, ' | ') 

Please don't try before answering the question!


Options are :

  • Five values i.e. Row 1 to Row 5
  • First value i.e. Row 1
  • Last value i.e. Row 5
  • Script Error Message

Answer :Five values i.e. Row 1 to Row 5

Users want list of years that are associated with a product id displayed in a text object as depicted below. Choose the correct expression.



Options are :

  • =Concat(DISTINCT Year,CHR(10))
  • =GetFieldSelections(Year)
  • =GetPossibleFieldSelections(year)
  • =Concat({}DISTINCT Year,CHR(10))

Answer :=Concat({}DISTINCT Year,CHR(10))

Become a Certified QlikView Expert Set 9

What is the difference between Clear and ClearAll?


Options are :

  • Clear action will not work on locked values but ClearAll action clears everything including locked values
  • With Clear action we can set customized/default selection state and ClearAll always clears everything including default selection states
  • There's no difference - both of them will ClearAll the selections
  • Clear action will not work on bookmark selected values but ClearAll action clears everything including bookmark selected values

Answer :With Clear action we can set customized/default selection state and ClearAll always clears everything including default selection states

Which of the following statement is FALSE about Comment Field:


Options are :

  • The map table used should always have two columns with any names
  • If multiple occurrences of a field name is found, the first value is used
  • Wildcard characters * and ? are allowed in field names
  • Field names not present in the document will be ignored

Answer :If multiple occurrences of a field name is found, the first value is used

What happen when you LOAD the QVD file without "(QVD)" format suffix?

Example: 


Options are :

  • None of the Above
  • Load Succeeds
  • Load Fails
  • Loads only XML header

Answer :Loads only XML header

When using alternate states does the bookmark apply to...?


Options are :

  • All States
  • Only Default State(s)
  • Can't apply bookmarks on alternate states
  • Only Inherited State(s)

Answer :All States

What is the result of the following expression in QlikView:

=COUNT(ValueLoop(-1, -10, -3)) 

*Please don't try before answering the question.


Options are :

  • NULL
  • 4
  • 0
  • 1000000
  • -4

Answer :4

What is the default Logical mode of Set Analysis when you have multiple Set Modifiers in the Set Expression?


Options are :

  • AND Mode
  • OR Mode
  • NOT Mode
  • ONLY Mode

Answer :AND Mode

Become a Certified QlikView Expert Set 1

What is the result of ApplyMap() expression when there is no matching value or the third parameter in the function?


Options are :

  • Returns Null Value
  • Return '0' for Number and '-' for Strings
  • Returns Expression or Lookup Value
  • Returns Empty String

Answer :Returns Expression or Lookup Value

Which of the following QlikView function(s) has implicit Distinct qualifier?


Options are :

  • Aggregation Functions like Sum(), Count() & Avg() etc
  • Concat()
  • Aggr()
  • FirstSortedValue()

Answer :Aggr()

Which of the following statement is TRUE about Qualify statement?


Options are :

  • Qualify statement doesn't work on Mapping Load and throws an error
  • Qualify works at load statement level
  • Qualify works until end of the script or until Unqualify is used
  • Only one Qualify statement can be used in the script

Answer :Qualify works until end of the script or until Unqualify is used

Become a Certified QlikView Expert Set 10

What happens when checking the "+" sign in the bookmarks dialog window (As show in the image)?




Options are :

  • Add current bookmark as temporary bookmark
  • Select more than one or multiple bookmarks from the list to edit/add the bookmark properties
  • Add additional properties to the checked item
  • Add this bookmark selection on top of the current selection

Answer :Add this bookmark selection on top of the current selection

You have been asked to show first payment date for each Order ID.

Choose the correct expression.



Options are :

  • FirstSortedValue(PaymentDate, aggr(only({}Type), PaymentDate, OrderID))
  • MinString(aggr(only({} PaymentDate), OrderID, PaymentDate))
  • FirstSortedValue(aggr(only({} PaymentDate), OrderID, PaymentDate))
  • MaxString(aggr(only({} PaymentDate), OrderID, PaymentDate))

Answer :MinString(aggr(only({} PaymentDate), OrderID, PaymentDate))

Users want to see top selling product for each country so you create a straight table and used AGGR function as inner aggregation function and max as an outer aggregation function and tested it to make sure that it works.

However, users want to see top selling product in a text object so you used same expression along with FirstSortedValue function in test box and it is not working. Why?

How will you make it work?

The following expression in a text object is not working.

='Top Selling Product: ' & chr(10) &
  FirstSortedValue(ProductName, max(total <Country> aggr(sum(LineSalesAmount), ProductName))) 


Options are :

  • Replace max(total aggr(sum(LineSalesAmount), ProductName)) with -aggr(sum(LineSalesAmount), ProductName)
  • Replace max(total aggr(sum(LineSalesAmount), ProductName)) with aggr(sum(LineSalesAmount), ProductName)
  • Replace max(total aggr(sum(LineSalesAmount), ProductName)) with max(total -aggr(sum(LineSalesAmount), ProductName))
  • Replace max(total aggr(sum(LineSalesAmount), ProductName)) with sum(aggr(sum(LineSalesAmount), ProductName))

Answer :Replace max(total aggr(sum(LineSalesAmount), ProductName)) with -aggr(sum(LineSalesAmount), ProductName)

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions