Become a Certified QlikView Expert Set 5

Which of the following statement(s) is/ are not True about the NULL values:


Options are :

  • QlikView creates NULL values as a result of a forced concatenation of tables
  • QlikView creates NULL values for ApplyMap() function where there is no match
  • QlikView identifies NULL values returned from an ODBC connection
  • QlikView creates NULL values as a result of a join statement where there is no match
  • All of the above statements are True

Answer :QlikView creates NULL values for ApplyMap() function where there is no match

You have joined AtoZ Food Corporation as a Qlik Developer. Your manager asked if there is a way to hide the script and the database connections but allowing to reload the script. Manager require this functionality immediately. You thought about QlikView "Hidden Script" feature. Which of the following statement is TRUE when "Hidden Script" in QlikView is used:


Options are :

  • Script Execution Window and Application Log file will not show the Script
  • Script Execution Window will not show the script but Application Log file will show the Script
  • Script Execution Window will show the script but Application Log file will not show the Script
  • Both Script Execution Window and Application Log file will show the script. However, we can't access Edit Script without password

Answer :Script Execution Window and Application Log file will not show the Script

Become a Certified QlikView Expert Set 6

For a typical LOAD or SELECT statement; what is the order of events :


Options are :

  • Evaluation of expressions Mapping of data if field name matches Renaming of fields by as Qualification of field names Renaming of fields by alias 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 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
  • Evaluation of expressions Qualification of field names Renaming of fields by as Mapping of data if field name matches Renaming of fields by alias 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 does "*" (star) wild card imply while loading Section Access?


Options are :

  • All the listed values in the Section Access
  • All the data values from the specific field in the data model
  • All the data values from all the fields in the data model
  • All the ADMIN users should have *

Answer :All the listed values in the Section Access

You have an include statement in your script. Someone mistakenly moved the variable.txt file to a different location. 

$(Include=c:\qlikviewtraining\designer11.2\include\variables.txt);

Will your script fail during the reload?


Options are :

  • No
  • Maybe
  • Yes

Answer :No

Become a Certified QlikView Expert Set 7

What is the use of "#" sign in the following script:


Options are :

  • # forces $ expansion using decimal point with comma and performs numeric comparison
  • # is always used in conjunction when SET keyword is used instead of LET
  • # is used to convert the variable to Dual() format
  • # is new feature in QlikView 12 to convert variable from string to number

Answer :# forces $ expansion using decimal point with comma and performs numeric comparison

Using Distinct qualifier in Count() forces QlikView to switch from using multi core to use only one core.


Options are :

  • FALSE
  • Don't know
  • TRUE

Answer :TRUE

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


Options are :

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

Answer :All States

Become a Certified QlikView Expert Set 8

What is the result of the following script? Assuming the schema is different in all three tables


Options are :

  • All the fields in three tables are loaded except the TransID field which will be excluded
  • Only TransID will be used for associations between the tables tab1, tab2 and tab3.
  • Syntax error because Qualify and Unqualify operators can ONLY be used with Load Statement and not directly on the SQL select statement

Answer :Only TransID will be used for associations between the tables tab1, tab2 and tab3.

What does Search statement do?


Options are :

  • This is a trick question: there is NO statement called Search in QlikView
  • The Search statement is used for searching Script and UI variables
  • The Search statement is used for including or excluding fields when using the search function

Answer :The Search statement is used for including or excluding fields when using the search function

Where can we use ValueLoop() Function?


Options are :

  • All of the Above
  • Only used in While Loop & For Loop in the script
  • Used in Calculated Dimension, Inside Aggregation Function & Concat Function
  • Only used for Calculated Dimension

Answer :Used in Calculated Dimension, Inside Aggregation Function & Concat Function

Become a Certified QlikView Expert Set 9

Which of the following statements is not TRUE :


Options are :

  • Using Addition : X + NULL returns NULL
  • Using Concatenation : 'X' & NULL returns X
  • Using Not Equal to : X < > NULL returns False(0)
  • Using Division : 0 / NULL returns NULL

Answer :Using Not Equal to : X < > NULL returns False(0)

What is the result of this expression: 

=RangeSum( Null(), 10 + Null())


Options are :

  • NULL
  • 0
  • 10
  • 1

Answer :0

What does ampersand (&) symbol in a List Box denote?


Options are :

  • Possible Values
  • Logical And-Mode
  • Multiple Values Selected
  • Forced Exclusion

Answer :Logical And-Mode

What happens when I reload (Ctrl + R) the below script :


Options are :

  • Only is an optional qualifier to load missing record from Table1
  • Syntax error - It should be Load only...instead of Only Load
  • Only function is used to select one field value
  • Only is an optional qualifier, which disregards NewEmployee.csv

Answer :Only is an optional qualifier, which disregards NewEmployee.csv

What is Subset Ratio in QlikView?


Options are :

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

Answer :Number of distinct values compared to the total distinct values in the field

Which of the following sources don't need to be in UPPER CASE while loading Section Access Script?


Options are :

  • Inline Table
  • Excel
  • CSV
  • All of above MUST be in UPPER CASE
  • ODBC/ OLEDB

Answer :Inline Table

Become a Certified QlikView Expert Set 1

What is the difference between WildMatch() and WildMatch5() functions?


Options are :

  • There is only WildMatch() function and there is nothing like WildMatch5()
  • WildMatch() accepts unlimited strings and WildMatch5() accepts only 5 strings to compare
  • WildMatch5() is used to compare Hash5 type strings and WildMatch() for usual text strings
  • Both are same but later is used for compatibility reasons with QlikView version 5

Answer :Both are same but later is used for compatibility reasons with QlikView version 5

Which of the following function(s) assumes implicit distinct qualifier


Options are :

  • Count()
  • FirstSortedValue()
  • Concat()
  • Aggr()
  • All of the above

Answer :Aggr()

Is it possible to convert Text Box object into a circle or diamond shape?


Options are :

  • No
  • Yes
  • Don't Know

Answer :Yes

Become a Certified QlikView Expert Set 10

When do you see Perfect Key in QlikView?


Options are :

  • None of the above
  • Key Field with 100% unique values
  • When Key Field is linked to more than 1 table(s)
  • When Information Density is 100%
  • Second Key Field in the same table is called Perfect Key
  • All of the above

Answer :Key Field with 100% unique values

What is the expected result in the variable overview window; once you reload the below script: 


Options are :

  • vValue1 = Evaluate(6+4) and vValue2 = Evaluate(6+4)
  • vValue1 = Evaluate(6+4) and vValue2 = $(vValue1)
  • vValue1 = Evaluate(6+4) and vValue2 = 10
  • vValue1 = 10 and vValue2 = 10

Answer :vValue1 = Evaluate(6+4) and vValue2 = Evaluate(6+4)

Is it possible to create a QVD file in UI without using script?


Options are :

  • Yes
  • No

Answer :Yes

Become a Certified QlikView Expert Set 2

In QlikView Load Script what is equivalent to SQL "Having" Clause? or how to filter data after using "Group By" clause in the QlikView Load Statement?


Options are :

  • Using Preceding Load with Where Clause
  • Not possible in QlikView hence use Having clause in Database
  • Using Only Function with Group By clause
  • Using `Having` Script Statement

Answer :Using Preceding Load with Where Clause

Which logic is implemented to handle NULLS in QlikView?


Options are :

  • Four-valued Logic
  • Three-value Logic
  • NULL()
  • Boolean Logic

Answer :Three-value Logic

You are working as a Sr. Qlik Consultant. You work together with Adam - Graduate Qlik Developer. 

You have written a Set Expression using Alternate States. However, Adam by mistake deleted the Alternate State which was used in Set Expression. Will will be the output?


Options are :

  • You can never remove state while it is used
  • Move to next available state
  • Show an error message
  • Revert to default state

Answer :Revert to default state

Become a Certified QlikView Expert Set 3

Which of the following is NOT a valid Qualifier which precedes the "Load" Statement?


Options are :

  • Partial Load....
  • Semantic Load....
  • Generic Load....
  • All of the above are true
  • Mapping Load....

Answer :Partial Load....

Following script fails during the reload. What is the cause of the failure?

Load FirstName& ' ' &LastName as Employee, Comment from Citizens.csv

where exists (Employee, Employee);



Options are :

  • Table name is missing
  • Exists function needs only one field name: Employee
  • Replace exists (Employee, Employee); with exists (Employee, FirstName& ' ' &LastName);

Answer :Replace exists (Employee, Employee); with exists (Employee, FirstName& ' ' &LastName);

What is the use of "Only" keyword in Partial Reload?


Options are :

  • Only is an optional qualifier which disregards the script during normal reloads
  • Loads/ Replaces only the distinct rows
  • A check for duplicates is made by `only` keyword in the previously loaded table
  • Only is a chart function and not a qualifier or keyword

Answer :Only is an optional qualifier which disregards the script during normal reloads

What is the use of DISTINCT qualifier in the FirstSortedValue() function?


Options are :

  • Distinct Qualifier is allowed but has no meaning
  • FirstSortedValued() always uses implicit Distinct Qualifier
  • Distinct can be used when the sorted values are NOT duplicates
  • We can't use Distinct Qualifier in the FirstSortedValue()
  • Distinct can be used when the sorted values are duplicates

Answer :Distinct can be used when the sorted values are duplicates

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions