Become a Certified QlikView Expert Set 6

Identify Set Analysis expression with proper syntax


Options are :

  • sum( ${=1000”}>} Sales)
  • sum( {$= {“1000”}>} Sales)
  • sum( {$= {1000}>} Sales)
  • sum( {$=1000”}>} Sales)

Answer :sum( {$=1000”}>} Sales)

Become a Certified QlikView Expert Set 7

Choose the best method to resolve the following synthetic table.




Options are :

  • By creating a composite key using Year, Month and Customer Number Fields in Budget and Sales tables and dropping Year, Month and Customer Number fields from the Budget table
  • By creating left join between Sales and Budget tables
  • By creating a Link table between Sales and Budget tables
  • By concatenating Sales and Budget tables

Answer :By creating a Link table between Sales and Budget tables

You have a date field where the date is stored as a string ‘20140131’  in the source database. What will you do to get the correct date representation in your app?


Options are :

  • None of the above
  • Use Date() to convert date into the right format
  • Nest Date and Date#; Date # will give the right date numeric value and date() will give the correct date format
  • Use DateTime to convert this datefield into right format

Answer :Nest Date and Date#; Date # will give the right date numeric value and date() will give the correct date format

Which function works similar to NVL SQL function if a field contains numeric values?


Options are :

  • NullAsValue() function
  • NullCheck() function
  • NullValue() function
  • ALT() function

Answer :ALT() function

Become a Certified QlikView Expert Set 8

How will following calculated dimension appear in a chart if vClass  = 23?

Class (vClass, 5, x) 



Options are :

  • 20<=x<25
  • 20<=x<=40
  • 20<= x <30
  • 20 <=vClass<20

Answer :20<=x<25

Choose Set expression for the following requirement – show sales for all categories except Babywear for all divisions .

Ignore all other user selections


Options are :

  • sum({1} Sales)
  • sum({$} Sales)
  • sum({ 1 Sales)
  • sum({} Sales)

Answer :sum({1} Sales)

Choose a TRUE statement for the Scatter plot chart.


Options are :

  • 3 expressions required : X and Y axis for two measures and third expression for the bubble size.
  • 2 expression required: Y-axis for measure, X-axis for dimension and optional expression for the bubble size
  • 2 expression required: X and Y axis for two measures and an optional expression for the bubble size.
  • 3 expressions required: Y-axis for measure, X-axis for dimension and one for the bubble size.

Answer :2 expression required: X and Y axis for two measures and an optional expression for the bubble size.

Become a Certified QlikView Expert Set 9

You want to show only sales amount > 500 but following script is not working. Select correct answer(s).



Options are :

  • drop Sales table at the end of the resident load
  • Add WHERE clause with the INLINE load statement
  • Remove Resident load and instead add a preceding load with WHERE clause to filter out records with sales amount less than 500
  • Add Noconcatenate prefix before the resident load

Answer :Add WHERE clause with the INLINE load statement Remove Resident load and instead add a preceding load with WHERE clause to filter out records with sales amount less than 500

A junior QlikView developer is struggling to calculate the sum of Quantity per OrderId where the ShipDate is the same as the RequiredDate.

He is using following IF statement but performance of the chart is bad due to large amount of data.

sum(if(ShipDate=RequiredDate,Quantity))

Which Set Analysis expression can replace the IF statement?


Options are :

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

Answer :sum({} Quantity)

How will you resolve the following synthetic key?




Options are :

  • Create a composite key between OrderID and LineNo in Transaction and Shipment tables and drop fields OrderID, LineNo from the shipment table
  • Rename ShipperID and LineNo fields in the Shipment table and ShipperID in the Orders table
  • Create a composite key between OrderID, LineNo and ShipperID in Shipment table and drop fields OrderID, LineNo and ShipperID from Shipment table
  • Create a composite key between OrderID and ShipperID in Shipment table and Orders table and drop OrderID and ShipperID from both tables

Answer :Create a composite key between OrderID and LineNo in Transaction and Shipment tables and drop fields OrderID, LineNo from the shipment table

Table viewer shows subset ratio of 98% in the Orders table and 100% in the Customers  table. What does that mean?


Options are :

  • 2% of customer names don’t match between Orders and Customers tables
  • 2% of customers are undefined in the customers table
  • 2% of customers never placed any orders
  • 2% of customers table records are having null values

Answer :2% of customers never placed any orders

Following is an example of which type of relationship ?




Options are :

  • Many to Many between Room and Booking. One to Many between Booking and Guest
  • Many to Many between Room and Guest
  • Options B and C
  • One to one between Room and Guest

Answer :Many to Many between Room and Guest

This script has syntax error. How will you fix it?



Options are :

  • Replace Previous with Peek in line 142.
  • You can’t perform a preceding load on a resident load statement.
  • You can’t add values from two fields in the preceding load statement.
  • Replace Peek with Previous in line 148.

Answer :Replace Previous with Peek in line 142.

Become a Certified QlikView Expert Set 1

One of your junior QlikView developers created a straight table with following expression but the chart is not showing any rows.  Help him identify root cause.

Sum({<Year = {$(max({1} Year))}>} Sales)


Options are :

  • Identifier 1 has to be added right after the first left curly bracket
  • Missing = before the max function
  • Missing angle brackets in the inner Set Analysis expression
  • Dollar expansion needs to be enclosed in single quote since it is a date field

Answer :Missing = before the max function

You have been asked to create a text object that shows last State where each employee worked based on a user selection of the name field.  Select expression for the text box.



Options are :

  • FirstSortedValue(max(ID), Name)
  • =FirstSortedValue(max(State), -ID)
  • =FirstSortedValue(State, -ID)
  • =max(aggr(max(State), Name))

Answer :=FirstSortedValue(State, -ID)

You have been asked to show orders that were shipped on the required date.

Select the correct Set Analysis expression.




Options are :

  • sum({} LineSalesAmount)
  • sum({} LineSalesAmount)
  • sum({} LineSalesAmount)
  • sum({} LineSalesAmount)

Answer :sum({} LineSalesAmount)

Become a Certified QlikView Expert Set 10

From a string  ‘Wonderful, I thought'  you have been asked to extract only word ‘thought’ from it. Which function will you use?


Options are :

  • mid('Wonderful, I thought', index('Wonderful, I thought', 't',1), 7)
  • subfield('Wonderful, I thought',',',2))
  • right('Wonderful, I thought',',',2))
  • mid('Wonderful, I thought', index('Wonderful, I thought', 't',1), 6)
  • Substring('Wonderful, I thought', 12, 6)

Answer :mid('Wonderful, I thought', index('Wonderful, I thought', 't',1), 7)

Choose the correct set expression for sales between today and past 3 months.


Options are :

  • =Sum({=' & MonthStart(Today() -3) & '<=' & MonthStart(Today()))"}>} Sales)
  • =Sum({=' & MonthStart(Today(), -3) & '<=' & MonthStart(Today()))"}>} Sales)

Answer :=Sum({

Select the correct Set Analysis expression. 


Options are :

  • sum({< [Category Name] =- {'Seafood'}>} LineSalesAmount)
  • sum({< [Category Name] *= {'Seafood'}>} LineSalesAmount)
  • sum({< [Category Name] -= {'Seafood'}>} LineSalesAmount)
  • sum({< [Category Name] = {'*' - 'Seafood'}>} LineSalesAmount)

Answer :sum({< [Category Name] -= {'Seafood'}>} LineSalesAmount)

Become a Certified QlikView Expert Set 2

Set Analysis expression with a modifier has two curly braces.

Identify sets for inner and outer curly braces


Options are :

  • Inner curly bracket is for the data set and outer curly bracket is for the record set
  • Inner curly bracket is for the element set and outer curly bracket is for the record set
  • Inner curly bracket is for the data set and outer curly bracket is for the filter set
  • Inner curly bracket is for the record set and outer curly bracket is for the element set

Answer :Inner curly bracket is for the element set and outer curly bracket is for the record set

Given a straight table, identify the data quality problem





Options are :

  • D. Same Country spelled differently
  • Options B and D
  • B. Same city spelled differently
  • Options A and D
  • A. Same city name for different countries
  • C. Sales Amounts are not correct. Should have decimals

Answer :Options B and D

Is following statement TRUE?

sum ({$ < [Customer Region]= {"*"} - {'AK'}>}  LineSalesAmount)  

same as 

sum ({$ < [Customer Region]=- {'AK'}>}  LineSalesAmount) ?


Options are :

  • No
  • Yes
  • Don't Know

Answer :Yes

Become a Certified QlikView Expert Set 3

In an enterprise clustered QlikView server and publisher environment,  service that performs  document reload and distribution at the back end is


Options are :

  • QVS
  • QDS
  • DSC
  • QMS

Answer :QDS

Which QlikView chart doesn't require dimension?


Options are :

  • Block Chart
  • Gauge Chart
  • Bar Chart
  • Radar Chart
  • Funnel Chart

Answer :Gauge Chart

If a string contains 'abcdef' and you have to extract only 'cd' from it, which function would you use?


Options are :

  • SubCat(abcdef,3,2)
  • Substring(abcdef,3,2)
  • Subfield(abcdef3,2)
  • Mid(abcdef,3,2)

Answer :Mid(abcdef,3,2)

Become a Certified QlikView Expert Set 4

You have been asked to create a straight table to show orders that were shipped within one week of order placement.

Choose correct Set Analysis expression


Options are :

  • sum({}LineSalesAmount)
  • sum({}LineSalesAmount)
  • sum({}LineSalesAmount)
  • sum({}LineSalesAmount)

Answer :sum({}LineSalesAmount)

Once this table is loaded, what values will be stored in the Quantity field(this is a comma delimited text file)?

ProductID, GroupID, Quanity 

111, 222, 1, 3345

666, 444, 2,567

777, 888, 3,435



Options are :

  • 0
  • 1,2,3
  • 1,3345 , 2,567 , 3,435

Answer :1,2,3

How many records will have the correct name in the “Country” field?





Options are :

  • 2 records
  • 4 records
  • Load will fail as key field ID is missing in the mapping load
  • 0 records

Answer :2 records

You have created a dashboard that has 35 tabs in the script, loads 15 tables or QVDs. This dashboard has 12 sheets and have 14 charts and tables. If one of the chart expressions changed and if the same expression is being used in 10 charts, what is the best way to change this expression in all 10 charts?


Options are :

  • Go to the script , find and replace the expression and reload data
  • Use variable overview, find and replace the variable definition
  • You have to find and replace expression in each of 10 charts manually
  • Use expression overview and find and replace your expression

Answer :Use expression overview and find and replace your expression

What is TRUE about the preceding load statement?


Options are :

  • Preceding load allows the use of QlikView functions in the load script
  • Preceding load appears after the select statement
  • All of the above
  • Preceding load can’t be used on another preceding load

Answer :Preceding load allows the use of QlikView functions in the load script

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions