Become a Certified QlikView Expert Set 8

What happens to Null values /rows after using the CrossTable prefix in the QlikView script?


Options are :

  • Nulls will remain as Nulls after CrossTable Load
  • Nulls will be removed after CrossTable Load
  • Only Distinct Nulls are kept after CrossTable Load
  • Nulls are converted to Zero Values after CrossTable Load

Answer :Nulls will be removed after CrossTable Load

What happens when you don't set the "NullValue" variable while using "NullAsValue" statement in QlikView Script?


Options are :

  • NullAsValue will replace the NULL values with '-' (Hyphen)
  • NullAsValue will not replace the NULL values
  • NullAsValue will replace the NULL values with 'Null' (Text)
  • NullAsValue will replace the NULL values with '' (Empty String)

Answer :NullAsValue will replace the NULL values with '' (Empty String)

When Text box object is used; what is the difference between:

=Count(TOTAL Product) 

and

=Count(Product) 


Options are :

  • Both the expressions will give same result because Total qualifier does not have any dimension filtering or grouping
  • Total qualifier expression is complete because no dimensions fields were specified
  • Expression with Total qualifier will return NULL value
  • Total qualifier expression will ONLY show the Grand Total and ignores any selections made in the app

Answer :Both the expressions will give same result because Total qualifier does not have any dimension filtering or grouping

Become a Certified QlikView Expert Set 9

What is the output of the following two expressions in text box object based on field selections in Product field:





Options are :

  • Apple and - (NULL) values respectively
  • Apple and Error values respectively
  • Apple and Apple values respectively
  • - (NULL) and - (NULL) values respectively

Answer :Apple and Apple values respectively

When do you see the Green Beacon/ Color Indicators on the sheet tabs in QlikView?


Options are :

  • When there is a field selection in different sheet and same field is not available in the current sheet
  • Beacons or Color Indicators only appear when there is a selection in Data Islands
  • Beacons or Color Indicators only appear when styling mode is "Advanced"
  • When there is a selection in hidden sheet

Answer :When there is a field selection in different sheet and same field is not available in the current sheet

Which of the following is a valid script statement(s) to remove the Circular Reference issue?


Options are :

  • Unmap Loosen Table [Table Name]
  • Drop Circular Reference [Table Name]
  • Loosen Table [Table Name]
  • Drop Synthetic Keys [Table Name]

Answer :Loosen Table [Table Name]

Which of these can NOT be done when loading data from a QVD file?


Options are :

  • Sorting
  • Grouping
  • Where clause
  • OMIT

Answer :Sorting

Which of statement is TRUE about Section Access?


Options are :

  • All the statements are true
  • When loading Section Access from an Excel file you must ensure the field values are in upper case
  • When loading Section Access using an Inline table you must ensure the field values are in upper case
  • When loading Section Access from a QVD file you must ensure the field values are in upper case

Answer :All the statements are true

While using the "Rename Fields" script statement; what happens when you rename the two differently named fields to the same name?


Options are :

  • QlikView Script Execution Fails
  • QlikView creates a Key Field
  • QlikView ignores the Second Field and renames the First Field
  • QlikView ignores the First Field and renames the Second Field

Answer :QlikView Script Execution Fails

Become a Certified QlikView Expert Set 1

Fields which are defined as system fields by using HidePrefix or HideSuffix behave as follows?


Options are :

  • Are visible using the GetCurrentSelections() function when selected
  • Are not visible in ‘Current Selections’ when one or more of their values have been selected
  • Are not visible in a List or MultiBox when ‘$Field’ is being interrogated
  • Cannot be used as a dimension or within an expression

Answer :Are not visible in ‘Current Selections’ when one or more of their values have been selected

Which of the following bookmarks are stored within the QVW file?


Options are :

  • Server Bookmark
  • User Bookmark
  • Temporary Bookmark
  • Document Bookmark

Answer :Document Bookmark

Which of these statements will stop a QVD load from being optimised?


Options are :

  • IF( BUSINESS_DATE = DATE( now() ), 1, 0) as [%BusinessDateFlag]
  • BUSINESS_DATE as [Business Date]
  • Load * [myFile.qvd] (QVD)
  • Where Exists(Date)

Answer :IF( BUSINESS_DATE = DATE( now() ), 1, 0) as [%BusinessDateFlag]

Become a Certified QlikView Expert Set 10

What does the following set expression mean to you:

=Count({<ProductID=>} Product) 


Options are :

  • Syntax Error: Incomplete Set Expression
  • It shows ProductID => 0. So, anything which has greater than "0" ProductID is filtered by the expression
  • Ignores ProductID field selections but rest all the field selections are applied
  • It is short hard version of using Aggr() function to group the data by ProductID

Answer :Ignores ProductID field selections but rest all the field selections are applied

You have joined SmartCar company as a QlikView developer. You were asked to develop an app. Manager at SmartCar company provided you 3 dimension tables - ProductDim, CustomerDim and SalesPersonDim. Transactional data is stored in the Access Database. And your manager asked to create a time dimension ONLY based on the working days and asked you exclude the holiday. You have been provided a list of holidays in the Holiday.XLSX file. How do you cater this requirement? 


Options are :

  • Create the Master Calendar and Use the NOT Exists function to exclude the Holidays
  • Create the Master Calendar and perform left join on Holidays.XLSX table
  • Create the Master Calendar and use FirstSortedValue script function to exclude the Holidays.XLSX table
  • Create the Master Calendar and perform outer join on Holidays.XLSX table

Answer :Create the Master Calendar and Use the NOT Exists function to exclude the Holidays

Looking at the below two diagrams. First diagrams show the problem and the second diagram show the solution. Based on these two diagrams which data modelling technique is used?

Problem:


Solution:



Options are :

  • Link Table
  • Mixed Granularity Table
  • Dimensional Modelling
  • Concatenated Dimension Table

Answer :Link Table

Become a Certified QlikView Expert Set 2

What is the output of the field "RowNumber" as shown in the example above?




Options are :

  • NULL
  • 0 0 0 0 0
  • 1 2 3 4 5

Answer :0 0 0 0 0

Maximizing screen object such as charts will generate unwanted window scroll bars when….?


Options are :

  • Size to Data is not checked in the layout menu
  • You are in Styling Mode ‘Simplified’
  • Your sheet has an object which has a negative X-pos or Y-pos in the layout menu
  • You’re using a monitor resolution less than 1920 x 1200

Answer :Your sheet has an object which has a negative X-pos or Y-pos in the layout menu

You are being interviewed by SmartCars Corporation for the Qlik Architect role. Interviewer showed the following diagram and asked you to define the relationship between Purchase Order and Stock Items.






Options are :

  • A Purchase Order has a many-to-many relationship with a Stock Item because a purchase order can refer to many stock items, and a stock item can be referred to by many purchase orders.
  • A Purchase Order has a many-to-one relationship with a Stock Item because a purchase order can refer to many stock item, and a stock item can be referred to only one purchase order.
  • A Purchase Order has a one-to-many relationship with a Stock Item because a purchase order can ONLY refer to one stock item, and a stock item can be referred to by many purchase orders.
  • A Purchase Order has a one-to-one relationship with a Stock Item because a purchase order can ONLY refer to one stock item, and a stock item can be referred to only one purchase order.

Answer :A Purchase Order has a many-to-many relationship with a Stock Item because a purchase order can refer to many stock items, and a stock item can be referred to by many purchase orders.

Become a Certified QlikView Expert Set 3

In the following Set Expression. What does " * " denote?

=Sum({1<Product = {'Apple'}> <strong>*</strong> <Customer = {'Bob'} >} Sales) 



Options are :

  • Set Multiplier
  • Set Identifier
  • Set Modifier
  • Set Operator

Answer :Set Operator

The legend will display over a chart when maximized when …….?


Options are :

  • The legend position / width has been altered using Ctrl + Shift
  • Layout Size to Data is checked
  • Limited Legend is not checked
  • Document Styling Mode isn't set to advanced

Answer :The legend position / width has been altered using Ctrl + Shift

In a chart when you Suppress Dimension which are Null do these ‘hidden’ numbers get included in the calculation when aggregating with a TOTAL qualifier? 

For example: Sum( TOTAL Sales)


Options are :

  • Yes
  • No

Answer :Yes

Become a Certified QlikView Expert Set 4

You are planning to deploy a QlikView application and your manager mentioned that users prefer to use multiple browsers. Which client would you select in QMC under Access Point Setting and Default Preferred Client?


Options are :

  • IE Plugin with webview for full flexibility
  • Full Browser and Small Device Version
  • IE Plugin
  • Download, meaning download of the .qvw files from the QlikView AccessPoint.

Answer :Full Browser and Small Device Version

Which of the following override QlikView selections and potentially ignore the current selections?


Options are :

  • Set Analysis
  • Alternate States
  • Dollar Sign Expansion
  • Aggr()

Answer :Set Analysis Alternate States

When you design QlikView app, which option can reduce the amount of space needed by allowing the same chart to be displayed by different dimensions?


Options are :

  • Cyclic Group
  • Multi Box
  • Lookup Dimension
  • Layer Group

Answer :Cyclic Group

Become a Certified QlikView Expert Set 5

Top tier investment bank invited you for an interview. Interviewer gave the following the script and asked to choose the right output after script execution. This is your final question and the interviewer decides your skills based on this question. 

No pressure! good luck!






Options are :

  • Emp1: EmpIDFirstNameLastName1823RogerSong2141DonaldFarmer -AdamPower -JohnSmith -PeterGoldman Emp3: RecIDRowIDFullName-1Roger Song-2Donald Farmer
  • Emp1: EmpIDFirstNameLastName1823RogerSong2141DonaldFarmer -AdamPower -JohnSmith -PeterGoldman Emp3: RecIDRowIDFullName--Roger Song--Donald Farmer
  • Emp1: EmpIDFirstNameLastName 1823 Roger Song 2141 Donald Farmer -Adam Power -John Smith -Peter Goldman Emp3: RecIDRowIDFullName 4 1 Roger Song 5 2 Donald Farmer
  • Emp1: EmpIDFirstNameLastName1823RogerSong2141DonaldFarmer -AdamPower -JohnSmith -PeterGoldman Emp3: RecIDRowIDFullName11Roger Song22Donald Farmer

Answer :Emp1: EmpIDFirstNameLastName 1823 Roger Song 2141 Donald Farmer -Adam Power -John Smith -Peter Goldman Emp3: RecIDRowIDFullName 4 1 Roger Song 5 2 Donald Farmer

In the following expression, what does "1" denote?

=Sum({1<Product = {'Apple'}> * <Customer = {'Bob'} >} Sales) 


Options are :

  • Set Operator
  • Set Identifier
  • Set Modifier
  • Set Flag

Answer :Set Identifier

While implement QilkView 11 bookmarks with Alternate States - What happens when applying the bookmark?


Options are :

  • We can't use bookmark selections with alternate states
  • Bookmark selections will only apply to default state
  • It's possible to apply bookmark selection to a specific state
  • Bookmark selections are always applied to all the states and they won't work for individual states

Answer :It's possible to apply bookmark selection to a specific state

Become a Certified QlikView Expert Set 6

You have recently joined AdventureWorks as a QlikView Developer. You were asked to deploy QlikView application. And your managers says that – users need “Report Editing” functionality. Which client would you use? 


Options are :

  • IE Plugin
  • HTML5 Client
  • OCX Client
  • AJAX ZFC

Answer :IE Plugin

You have a data island field (INLFED) in Temp.QVW with the following values. You have created a new file "Temp2.QVW" with the following script. What will be the output?




Options are :

  • MyField BAR BAZ FOO TEST TEST1 TEST2
  • MyField BAZ
  • Two Tables: One Table with all the values and another table with only {BAZ}
  • Script Error

Answer :MyField BAZ

Considering the following script which has two tables. What do you use to make them two separate tables and having associated join on the field ID?




Options are :

  • LOAD ID, Name as Table1_Name, Address as Table1_Address from table1.csv; Noconcatenate LOAD ID, Name as Table2_Name, Address as Table2_Address from table2.csv;
  • LOAD ID, Name, Address from table1.csv; Concatenate LOAD ID, Name, Address from table2.csv;
  • LOAD ID, Name, Address from table1.csv; Noconcatenate LOAD ID, Name, Address from table2.csv;
  • LOAD ID, Name, Address from table1.csv; Inner Join LOAD ID, Name, Address from table2.csv;

Answer :LOAD ID, Name as Table1_Name, Address as Table1_Address from table1.csv; Noconcatenate LOAD ID, Name as Table2_Name, Address as Table2_Address from table2.csv;

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions