Become a Certified QlikView Expert Set 2

Which of the following statement is True in QlikView?


Options are :

  • = '11' < '2'
  • = 1 Follows 0
  • = 11 < 2
  • = '11' Follows '12'

Answer := 1 Follows 0

Become a Certified QlikView Expert Set 3

Is it possible to use more than one Binary statement in a QlikView script?


Options are :

  • Only one Binary Load is allowed
  • No restriction on Binary Load as long as each of the QVW files contain only ONE table in the App
  • Yes, two Binary Loads are available in QV 12.10 prior versions allow only one Binary Load
  • Multiple Binary Loads are allowed as long as the respective QVW files does not have Section Access Script

Answer :Only one Binary Load is allowed

Which fields are impossible to show frequency in list boxes?


Options are :

  • Mapping Fields
  • System Fields
  • Key Fields
  • Primary Key Fields

Answer :Key Fields

You have been provided with below three tables. What will be the outcome if you load them in QlikView?




Options are :

  • Star Schema
  • Concatenated Schema
  • Snowflake Schema
  • Circular Reference

Answer :Circular Reference

Become a Certified QlikView Expert Set 4

Considering data modelling best practices:

Which layer do you prefer to calculate new fields in FACT table? 


Options are :

  • Application Load Layer
  • Generic Load Layer
  • Extraction Layer
  • Transformation Layer

Answer :Transformation Layer

Which of the following DSN connections are NOT stored in the Registry while setting up ODBC?


Options are :

  • File DSN
  • System DSN
  • User DSN
  • None of the above

Answer :File DSN

Looking at the following two images:

Which of the following code generates the output shown in second image?

Input:

Output:


Options are :

  • Crosstable (Year, Month, Sales) LOAD * from data.xlsx;
  • Crosstable (Year, Month, Sales, 2) LOAD * from data.xlsx;
  • Crosstable (Month, Sales, 2) LOAD * from data.xlsx;
  • Crosstable (Month, Sales) LOAD * from data.xlsx;

Answer :Crosstable (Month, Sales, 2) LOAD * from data.xlsx;

Become a Certified QlikView Expert Set 5

In QlikView, which of the following components are not part of prj folder?


Options are :

  • LoadScript
  • Module
  • Shared Files
  • AllProperties
  • DocBinary

Answer :Shared Files

Which of the following is the default ErrorMode value/code in QlikView?


Options are :

  • 8
  • 0
  • 1
  • 2

Answer :1

Which of the following statement(s) is NOT true about License Leasing?


Options are :

  • Named User CAL is used for License Leasing
  • License Leasing is also possible using the AJAX Client
  • After borrowing the License, user can work offline for 30 days
  • License Leasing is available in QlikView 12.1

Answer :License Leasing is also possible using the AJAX Client

Become a Certified QlikView Expert Set 6

Which of the following is NOT a control statement in QlikView?


Options are :

  • For...next
  • Exit Script
  • Call
  • Store

Answer :Store

Which of the following statement(s) is NOT true about Joins in Qlik?


Options are :

  • C. No field in common will render the cartesian product of the tables
  • B. The number of fields to join over is arbitrary
  • D. Unless a table name of a previously loaded table is specified in the join statement the join prefix uses the last previously created table
  • A. The names of the fields to join over must be exactly the same
  • E. None of the above

Answer :E. None of the above

What will be the variable value of the expression: 

($(#MyVariable) + 5)  

when MyVariable doesn't exist?


Options are :

  • 5
  • 0
  • String Value: ' + 5'
  • Null

Answer :5

Become a Certified QlikView Expert Set 7

Can we store variable values in Bookmark?


Options are :

  • No
  • Yes

Answer :Yes

As you are aware, with QlikView Personal Edition, Qlik offers a free version of QlikView for personal use. It is meant for individuals, students or small start-ups. QlikView Personal Edition is the full QlikView Desktop product and uses the same installation package. The only difference is that QlikView Personal Edition runs without a license key.

You have joined a startup called "DataViz Experts" and evaluating QlikView. Your boss shared a QVW file for you to open and you have already exceeded the number of recovery attempts. Your manager asked if there is a workaround. What do you do?



Options are :

  • Change the registry setting under HKEY >> Local Machine >> Current Set >> QlikView
  • Uninstall and reinstall QlikView desktop edition. This will reset the number of attempts.
  • Tell your manager that we need to buy the license(s) if we need to open/share others apps/documents

Answer :Tell your manager that we need to buy the license(s) if we need to open/share others apps/documents

What is the result of the following expression where 

vMyVariable = '\\Ipaddress\Folder_01\Folder_02\Folder_03'  ?

SubField(vMyVariable, '\', -1) 

(Please don't try before answering!)


Options are :

  • \
  • Ipaddress
  • Folder_02
  • Folder_03
  • None of the above (Trick Question!)

Answer :Folder_03

Become a Certified QlikView Expert Set 8

When modifying the Definition.xml file of an extension object, how can you see the changes made in the QlikView Client?


Options are :

  • Press ClearAll button
  • Reload the QlikView script
  • Refresh the Webpage
  • Re-add the Extension object

Answer :Re-add the Extension object

Which of the following is not true about the QVD files?


Options are :

  • Faster load times for large data sets:
  • All of the above
  • Less overhead on databases and networks
  • Reduced file size of extracted data
  • High level of security

Answer :High level of security

You are asked to calculate inception-to-date revenue. Here are the rules:

1. If the user selects a date then show the inception-to-date revenue as of that selection

2. If the user selects a range of dates then show the inception-to-date revenue for the Max(Date) of the current selections

3.If the user does not select any date then show the inception-to-daterevenue for all the days

Considering the above requirements. What is the correct Set Modifier?


Options are :

  • Sum({<[%Key_DateId] = {"<=$(exp_CurrentSelected_Date)"}>} NetRevenue)
  • Sum({<[%Key_DateId] in {"$(exp_CurrentSelected_Date)"}>} NetRevenue)
  • Sum({<[%Key_DateId] <= {"=$(exp_CurrentSelected_Date)"}>} NetRevenue)
  • Sum({<[%Key_DateId] <= {"$(exp_CurrentSelected_Date)"}>} NetRevenue)

Answer :Sum({<[%Key_DateId] = {"<=$(exp_CurrentSelected_Date)"}>} NetRevenue)

Become a Certified QlikView Expert Set 9

What is the result of the expression: 

Fact(-5)  

in QlikView?


Options are :

  • 120
  • Null
  • 25
  • -120
  • -25

Answer :Null

Which of the following statement is TRUE when Hidden Script in QlikView is used:


Options are :

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

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

Which of the following statement(s) is TRUE about Input Fields in QlikView?


Options are :

  • Input fields are not meant for large amounts of data, as they store data significantly less efficiently than regular fields.
  • All of the statements are TRUE
  • If a file is loaded using the binary statement, fields defined as input fields will not be treated as input fields.
  • A calculated field cannot be used as input field. The input field functionality will automatically be disabled.

Answer :All of the statements are TRUE

How can you assign a "Field Event Trigger" for a Hidden Field which uses the HidePrefix to hide the Field?


Options are :

  • Use a Variable to link the Field Selection and use the Variable Event Triggers
  • Select Show System Field and then assign the Field Event Trigger
  • Not possible to assign a Field Event Trigger for the Hidden Fields
  • Duplicate the Field in the Script as regular field and use this Field in Trigger

Answer :Select Show System Field and then assign the Field Event Trigger

In Set Analysis modifier, an expression with dollar-sign expansion always precedes with = sign. 


Options are :

  • Only if dollar-sign expansion contains a variable
  • True
  • False

Answer :True

Become a Certified QlikView Expert Set 1

Which of the following command pauses QlikView script execution?


Options are :

  • Stop
  • Wait
  • Pause
  • Sleep

Answer :Sleep

You have been asked to suggest how to improve performance of a QlikView application. Select statements that apply.


Options are :

  • Drop unused fields from the application
  • Avoid using Section Access
  • Avoid using calculated dimensions if possible
  • Use autonumber function for long alphanumeric keys
  • Split a field with high cardinality into multiple fields if possible
  • Convert all chart expressions into Set Analysis expressions

Answer :Drop unused fields from the application Avoid using calculated dimensions if possible Use autonumber function for long alphanumeric keys Split a field with high cardinality into multiple fields if possible

You have created a cyclic group with group name  Cyclic Group and it contains field values with spaces such as Country field contains United States and United Kingdom.

You created a straight table to show sales amount and maximum sales amount with cyclic group as dimension but maximum sales value expression is not working. 

How will you fix the expression syntax?

Expression for Max Sales Amount:

Max(total  aggr( sum(Amount), $(=getcurrentfield([Cyclic Group]))))


Options are :

  • Replace expression with Max(total aggr( sum(Amount), [$(=getcurrentfield([Cyclic Group]))]))
  • Cyclic group field is not allowed within a dollar-sign expansion
  • replace getcurrentfield with getcurrentfieldselections
  • Replace getcurrentfield([Cyclic Group]) with getcurrentfield(Cyclic Group)

Answer :Replace expression with Max(total aggr( sum(Amount), [$(=getcurrentfield([Cyclic Group]))]))

QlikView is built on following architecture design pattern:


Options are :

  • Service-oriented Architecture
  • Rule-based Architecture
  • Peer-to-peer Architecture
  • Data-centric Architecture

Answer :Service-oriented Architecture

Which of the following statement is FALSE about ValueLoop() function in QlikView?


Options are :

  • Synthetic dimension created with the valueloop function, it is possible to reference the dimension value corresponding to a specific expression cell by restating the valueloop function
  • Apart from when used for synthetic dimension it will only be meaningful inside an aggregation function
  • We can use ValueLoop in calculated dimension to form a synthetic dimension
  • ValueLoop() function will not work inside the Variables

Answer :ValueLoop() function will not work inside the Variables

What is the result of the following expression: 

FirstWorkDate('02/01/2015', 2, '01/01/2015') 

when:



Options are :

  • 31/12/2014
  • 5/1/2015
  • 6/1/2015
  • 30/12/2014

Answer :31/12/2014

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions