Become a Certified QlikView Expert Set 4

What is the result of the following expression in QlikView?

= SUM( '1' + 1 ) 

*Please don't try before answering the question.


Options are :

  • NULL
  • Error in expression: Sum takes 1 parameter
  • 2
  • 1

Answer :2

What is Information Density in QlikView?


Options are :

  • Number of key fields compared to total number fields in the table
  • Number of Not NULL records in the field compared to the total records in the table
  • Number of NULL values in the field compared to the total values in the table
  • Number of distinct values compared to the total values in the field

Answer :Number of Not NULL records in the field compared to the total records in the table

What does ~ (tilde) represent in the Search Object?


Options are :

  • Default Search
  • Fuzzy Search
  • Wildcard Search
  • Associated Search

Answer :Fuzzy Search

Become a Certified QlikView Expert Set 5

You are using FirstSortedValue function to show the color associated with maximum quantity sold in a text object but the text object shows null value.

Expression:

=FirstSortedValue(Color, -SoldQty)

Why are you seeing null value in the text object?


Options are :

  • Minus sign is not allowed in the FirstSortedValue function
  • FirstSortedValue function requires an aggregation function as second parameter
  • FirstSortedValue function requires an expression as first parameter
  • FirstSortedValue function returns null when multiple rows have same sort weight

Answer :FirstSortedValue function returns null when multiple rows have same sort weight

A junior developer needs your help to improve performance of a straight table that has aggr() function in the expression to calculate sales by country.

sum(total < Country> aggr(sum(LineSalesAmount), Country, CategoryName))

Choose an expression to replace aggr() function.



Options are :

  • sum(total LineSalesAmount)
  • sum( TOTAL LineSalesAmount)
  • sum(total LineSalesAmount)
  • sum(total LineSalesAmount)

Answer :sum(total LineSalesAmount)

What is the relationship between Insurance company and Patient tables?




Options are :

  • one-to-many
  • one-to-one
  • many-to-many
  • many-to-one

Answer :many-to-many

Become a Certified QlikView Expert Set 6

In order to improve performance on a chart with large amount of data, you have been challenged to replace IF statement with a Set Analysis expression.

The chart displays customers with top 4 sales amount as depicted below:

The chart expression is as follow:

If(Sum(Sales)>=Max(TOTAL Aggr(Sum(Sales), Customer), 4), Sum(Sales))

What will be the correct Set Analysis expression to replace this IF statement?


Options are :

  • sum({=Max(TOTAL Aggr(Sum(Sales), Customer), 4)"}>} Sales)
  • sum({=Max(TOTAL Aggr(Sum(Sales), Customer), 4)"}>} Sales)
  • sum({=Max(TOTAL Aggr(Sum(Sales), Customer), 4)"}>} Sales)
  • sum({=Sum(Sales) > Max(TOTAL Aggr(Sum(Sales), Customer), 4)"}>} Sales)

Answer :sum({=Max(TOTAL Aggr(Sum(Sales), Customer), 4)"}>} Sales)

What happens when we disable the "Sort Indicator" option under "Presentation Tab" for the Straight Table in QlikView?


Options are :

  • QlikView will hide the sort indicator icon next to the column header but you can still sort by double clicking on the column header
  • Don't know the answer and don't want to guess
  • QlikView will hide the sort indicator icon next to the column header and you can't sort anymore by double clicking on the column header
  • QlikView will show the sort indicator icon next to the column header but you can't sort anymore by double clicking on the column header

Answer :QlikView will hide the sort indicator icon next to the column header but you can still sort by double clicking on the column header

Following script reloads successfully but Age Group field shows no values. How will you fix this issue?



Options are :

  • Match field requires field name and a comparison is not allowed so replace Age <= 10 with Age
  • Replace match(Age <= 10, 10, 20) with match(Age <= 10, 1, 0)
  • Replace match(Age <= 10, 10, 20) with match(Age <= 10, -1, 0)
  • Replace pick function with peek function
  • Replace Pick(match(Age <= 10, 10, 20), 10,20) with Pick(match(Age <= 10, 10, 20), -1, 0)

Answer :Replace match(Age <= 10, 10, 20) with match(Age <= 10, -1, 0)

Become a Certified QlikView Expert Set 7

Which of the following functionality may not work in QlikView if the Print Spooler service is disabled?


Options are :

  • None of the above
  • PDF report generation
  • Export to Excel
  • Copy image to clipboard

Answer :PDF report generation

You have field called "SalesAmount" in the Fact table. You are using variables to store the expressions as containers and you intend to use the dollar sign expansion (lazy evaluation) in the objects. 

However you have misspelled the Field name: "SaleAmount" instead of "SalesAmount". 

What will be the output when you use the following expression?

=$(vTotalSales) 


Options are :

  • 0
  • NULL
  • QlikView smart search takes care of incorrect field names and the expression returns Total Sales
  • Error Message: Missing Field "SaleAmount"

Answer :0

Become a Certified QlikView Expert Set 8

What does the value 100 represent in Green(100) function?


Options are :

  • Darkest Shade of Green
  • Hex Code
  • RGB Code
  • Opacity

Answer :Opacity

What is the result of the following expression:


Options are :

  • -6
  • -120
  • 120
  • 6
  • NULL

Answer :120

Which is the best option between Num() function vs Number Format Settings?


Options are :

  • Num() function with expression default option otherwise Number Format Settings
  • Num() function for Set Analysis expression otherwise Number Format Settings
  • It's always Number Format Settings
  • Num() function because expressions are always evaluated at the end

Answer :Num() function with expression default option otherwise Number Format Settings

Become a Certified QlikView Expert Set 9

Based on the following ER diagram, what is the relationship between Customer and Purchase Order?




Options are :

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

Answer :One-to-Many

What is Sort by Applicability?


Options are :

  • All of the above
  • Sorting Field Values by Expression
  • This sort option is not available in QlikView
  • Sorting Field Values by Possible Values
  • Sorting Fields by Possible Field Values in Multibox

Answer :Sorting Fields by Possible Field Values in Multibox

How many DISTINCT values can we load in one QlikView field?


Options are :

  • It depends on the operating system
  • 4,294,967,296
  • No limit
  • 2,147,483,648

Answer :2,147,483,648

Which of the following provide functionality to save a QlikView document into several files that can be used for versioning. Each file defines a property of the document, a sheet, an object, the script etc.


Options are :

  • .Shared File
  • SVN
  • QlikView Bookmark Shared File Viewer
  • .Meta File
  • QlikView Project Files

Answer :QlikView Project Files

What is the result of the below script while query SQL Server table with OLEDB connection:First 11 SELECT TOP 10 * FROM DB.dbo.TableName;


Options are :

  • Script fails because `First` prefix is only used with LOAD and not with SELECT
  • Script fails because of conflicting SELECT statement
  • QlikView ignore the T-SQL `TOP` clause and extracts 11 rows
  • QlikView will extract 10 rows without any error

Answer :QlikView will extract 10 rows without any error

QlikView platform (QlikView Desktop, QlikView Server & Publisher etc.) is built on the following design pattern?


Options are :

  • Data-centric Architecture
  • Rule-based Architecture
  • Service-oriented Architecture
  • Associated-Data Architecture

Answer :Service-oriented Architecture

Become a Certified QlikView Expert Set 1

You have recently joined AtoZ Food Corporation as a Qlik Developer. They are a retail supermarket chain. Following dashboard has been built by existing Qlik Developer. The granularity of data is at the order detail or line item level where each order has multiple rows showing line items. And looking at the object highlighted in red what will be the impact of adding below three expressions when selections are made on Master Calendar Fields.






Options are :

  • Both - Expression_02 and Expression_03 yield same result and Expression_01 show different result
  • All three expressions yield same result
  • Both - Expression_01 and Expression_02 yield same result and Expression_03 shows different result
  • All three expression yield different results

Answer :Both - Expression_01 and Expression_02 yield same result and Expression_03 shows different result

What does the following ER relationship mean to you?




Options are :

  • One A is associated with One or More B
  • One A is associated with One B
  • One A is associated with Zero or One B
  • One A is associated with Zero or More B

Answer :One A is associated with Zero or One B

What happens when there are no common fields while using explicit Inner Join Statment between two tables in QlikView?


Options are :

  • QlikView generates - Field not found error message
  • QlikView Script Fails
  • QlikView ignores the Join statement and loads two seperate tables
  • QlikView generates Cartesian Product

Answer :QlikView generates Cartesian Product

Become a Certified QlikView Expert Set 10

Which of the following is NOT a QlikView Function?


Options are :

  • StateName()
  • GetNotSelectedCount()
  • ClientPlatform()
  • Bottom()
  • All of the above are QlikView Functions

Answer :All of the above are QlikView Functions

Which of the following statement(s) is TRUE about QlikView function(s)?


Options are :

  • Concat function always takes implicit Distinct Qualifier by default
  • Count function always takes implicit Distinct Qualifier by default
  • All three functions - Aggr(), Count() and Concat() takes implicit Distinct Qualifier by default
  • Aggr function always takes implicit Distinct Qualifier by default

Answer :Aggr function always takes implicit Distinct Qualifier by default

Looking at the below picture - what is the difference between "Clear" and "ClearAll"?



Options are :

  • 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 locked values but ClearAll action clears everything including locked values
  • 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

Become a Certified QlikView Expert Set 2

How to hide field selection in current selection box?


Options are :

  • Using OMIT Field in the Script
  • Using Hide Field property on Current Selection Box
  • Hide Prefix statement in the Script
  • HideField() script function

Answer :Hide Prefix statement in the Script

Based on the following ER diagram, what is the relationship between Purchase Order and Stock Item?





Options are :

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

Answer :Many-to-Many

How to convert/ transpose one field values to multiple fields in QlikView?


Options are :

  • Using CrossTable Statement
  • Using Mapping Tables
  • Using Generic Statement
  • Using Transpose Statement

Answer :Using Generic Statement

What will be the output of the following expression in the Text Box:


= (-3 < -2) < True() 




Options are :

  • 0
  • True
  • NULL
  • -1

Answer :0

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions