Become a Certified QlikView Expert Set 7

You are Set Analysis expert so another QlikView developer needs your help to write Set Analysis expression instead of a calculated dimension. 

Choose correct expression.


Options are :

  • sum({<[Category Name] = {"=rank(sum(LineSalesAmount)) <= 3"}>}LineSalesAmount)
  • sum({<[Category Name] = {"=rank(sum(LineSalesAmount) <= 3"}>}LineSalesAmount)
  • sum({<[Category Name] = {"<=rank(sum(LineSalesAmount)) = 3"}>} LineSalesAmount)
  • sum({<[Category Name] = {"rank(sum(LineSalesAmount)) <= 3"}>}LineSalesAmount)

Answer :sum({<[Category Name] = {"=rank(sum(LineSalesAmount)) <= 3"}>}LineSalesAmount)

Become a Certified QlikView Expert Set 8

You need to ignore selections on these two fields: ProductName, FirstName.

You have created following variable:

let vIgnore = "ProductName =, FirstName=";

and added this expression in the straight table:

sum({<$(vIgnore)>}LineSalesAmount)

But this gives no result. 


Choose all possible correct answers.



Options are :

  • Replace Let with Set
  • Replace sum({<$(vIgnore)>}LineSalesAmount) with sum({<$(=vIgnore)>}LineSalesAmount)
  • Replace let vIgnore = "ProductName =, FirstName="; with let vIgnore = 'ProductName =, FirstName=';
  • Keep let and replace sum({<$(vIgnore)>}LineSalesAmount) with sum({}LineSalesAmount)

Answer :Replace Let with Set Replace let vIgnore = "ProductName =, FirstName="; with let vIgnore = 'ProductName =, FirstName='; Keep let and replace sum({<$(vIgnore)>}LineSalesAmount) with sum({}LineSalesAmount)

This script generated an error. Why?

Table1:

Load

ProductID ,

Location,

Region

From product;

 

Table2:

Load

ProuctID,

Location,

Region

From product2;

 

LEFT JOIN 

Load

ProductID,

TransactionID,

Amount

From Sales2;



Options are :

  • Table2 is no longer available
  • Sales2 table may not exist in the database
  • Table name is missing after the left join statement
  • Left join keyword has to be in lowercase

Answer :Table2 is no longer available

While you develop a QlikView application, you want to speed up development by not reloading table data from the relational source unless you change your LOAD statement or SQL SELECT statement since you are working with a large fact table.  

Select LOAD statement that works best.


Options are :

  • Resident load
  • Semantic load
  • Limited load
  • Buffer load

Answer :Buffer load

Become a Certified QlikView Expert Set 9

You have been asked to create a pivot table that shows sales and top customer sales for given month and product. Choose correct expression.




Options are :

  • Max ( Aggr( Sum(Sales) , Month, Customer, Product) )
  • Max ( TOTAL Aggr( Sum(Sales) , Month, Product))
  • Aggr(Max (Sum(Sales) , Month, Customer, Product), month, product))
  • Max ( TOTAL Aggr( Sum(Sales) , Month, Customer, Product))

Answer :Max ( TOTAL Aggr( Sum(Sales) , Month, Customer, Product))

What are exceptions for the optimized QVD load? (select multiple answers that apply)


Options are :

  • If you use exists function with one parameter
  • If you use exists functions with two parameters
  • If you use 1=1 in the WHERE clause of the LOAD statement
  • if you create a new field
  • If you alias a column

Answer :If you use exists function with one parameter If you alias a column

You have been asked to display store with highest price for each product in a straight table. Choose the correct expression.




Options are :

  • E. max(sum(Price))
  • A FirstSortedValue(Store, -Price, 1)
  • B. max(Aggr(sum(Price), Product, Store))
  • D. FirstSortedValue(Product , -Store, 1)
  • C. FirstSortedValue(Price, -Store, 1)

Answer :A FirstSortedValue(Store, -Price, 1)

Which of the following load statements is an optimized load?


Options are :

  • All of above
  • Select ACTYPEID, Name From ac.qvd(qvd) WHERE Exists([%Aircraft Type ID], ACTYPEID);
  • None of above
  • Select ACTYPEID, Name From ac.qvd(qvd) WHERE Exists(ACTYPEID);

Answer :Select ACTYPEID, Name From ac.qvd(qvd) WHERE Exists(ACTYPEID);

A junior QlikView developer created following script but both MinDate and MaxDate values are NULL.  

What should he do to fix the issue?



Options are :

  • Remove single quotes around field name OrderDate in the LOAD statement
  • Replace rowno() with recno() function
  • Add rowno() function with the FieldValueCount function
  • Use num# function instead of num function for datevformatting

Answer :Replace rowno() with recno() function

What will be the output of the following load statement?




Options are :

  • Table 1 with 3 columns and 4 rows
  • Table 1 with 4 columns and 3 rows
  • Two tables. Table 1 will have 3 columns and 3 rows. Table 2 will have 3 columns and 3 rows
  • Two tables. Table 1 will have 3 columns and 2 rows. Table 2 will have 4 columns and 3 rows

Answer :Two tables. Table 1 will have 3 columns and 3 rows. Table 2 will have 3 columns and 3 rows

Become a Certified QlikView Expert Set 1

How will you resolve this circular reference?




Options are :

  • Rename CompanyName field in the Shippers table
  • Rename ShipperID in the Shippers table
  • Create composite key using Shipper ID and OrderID fields
  • Rename Customer ID field in the Orders table

Answer :Rename CompanyName field in the Shippers table

In the following pivot table, what is the expression used in Amount2 Column?




Options are :

  • Sum(Total Amount)
  • Sum(Total Amount)
  • sum(All Amount)
  • Sum(Total Amount)

Answer :Sum(Total Amount)

Choose the correct crosstable syntax. 




Options are :

  • CrossTable(EmployeeID, SalePerson, Quarter, 2)
  • CrossTable(QuotaQuarter, QuotaAmount, 2)
  • CrossTable(EmployeeID, SalePerson, Quarter, 1)
  • CrossTable(2, QuotaQuarter, QuotaAmount)

Answer :CrossTable(QuotaQuarter, QuotaAmount, 2)

Become a Certified QlikView Expert Set 10

What is the correct expression to calculate Average sales as shown in the chart below?



Options are :

  • avg(total aggr(sum(Swimwear), Year, DivisionName))
  • avg(total aggr(sum(Swimwear), Year, DivisionName))
  • avg(total aggr(sum(Swimwear), Year, DivisionName))
  • avg(aggr( total sum(Swimwear), Year, DivisionName))

Answer :avg(total aggr(sum(Swimwear), Year, DivisionName))

QlikView employs 2 types of data reductions: Dynamic data reduction and Static data reduction.  Select the best answer.


Options are :

  • B. Static data reduction is done thru loop and reduce in QlikView Publisher
  • D. Dynamic data reduction is done thru loop and reduce in QlikView Publisher
  • Options C,D
  • C. Static data reduction is done thru Loop and Reduce in QlikView script
  • A. Dynamic data reduction is done thru section access which is a part of the QlikView document
  • Options A, B

Answer :Options A, B

While developing an application, you are required to count the occurrence of a particular sub string in a string text. If your string text is 'abcdefgcdxyz', how will you count the occurrence of sub string 'cd'?


Options are :

  • Use subfield() function along with count() function
  • Use getsubstring() function
  • Use the substringcount() function

Answer :Use the substringcount() function

Become a Certified QlikView Expert Set 2

If you want to use FieldValue function in a chart, which function will you use for the elem_no?

Syntax: FieldValue(Field_name, elem_no)


Options are :

  • rowno()
  • recno()
  • iterno()
  • Either rowno() or recno()

Answer :rowno()

Choose correct statement regarding QlikView licenses


Options are :

  • Named CAL allows user to open unlimited # of documents for unlimited time; session CAL allows user to open one document for one hour per day; Usage CAL allows user to open one document for 15 mins; document CAL allows user to open one document for an hour per day.
  • Named CAL is assigned to a User who can access unlimited QlikView documents deployed in one QlikView Server; A Session CAL allows any user, identified or anonymous/unidentified user to access Qlikview Dashboards deployed in the Server for a minimum period of 15 minutes; A Usage CAL allows any user to access one QlikView Dashboard deployed in QlikView Server from one client for a period of 60 minutes per 28-day period; A Document CAL allows one user to open one specific QlikView Dashboard deployed in QlikView Server.
  • Named CAL allows user to open unlimited # of documents for unlimited time; session CAL allows user to open one document for 15 mins; Usage CAL allows user to open one document for once every 30 days; document CAL allows user to open a specific document for unlimited time.
  • Named CAL allows user to open unlimited # of documents for unlimited time; session CAL allows user to open one document for one hour; Usage CAL allows user to open one document for once every 28 days; document CAL allows user to open a specific document for unlimited time.

Answer :Named CAL is assigned to a User who can access unlimited QlikView documents deployed in one QlikView Server; A Session CAL allows any user, identified or anonymous/unidentified user to access Qlikview Dashboards deployed in the Server for a minimum period of 15 minutes; A Usage CAL allows any user to access one QlikView Dashboard deployed in QlikView Server from one client for a period of 60 minutes per 28-day period; A Document CAL allows one user to open one specific QlikView Dashboard deployed in QlikView Server.

Which expression will render accurate result in the straight table as depicted? Today is March 7, 2017




Options are :

  • if(min([#Delivery Date]) < vToday, sum(Amount))
  • if(max([#Delivery Date]) < $(vToday), sum(Amount))
  • sum(if([#Delivery Date] < vToday, Amount,0))
  • if([#Delivery Date]) < $(vToday), sum(Amount))

Answer :if(min([#Delivery Date]) < vToday, sum(Amount))

Become a Certified QlikView Expert Set 3

If you reload following script and create a table box, how many rows it will have and what will be total sales amount?



Options are :

  • 3 rows and $1300
  • 5 rows and $700
  • 5 rows and $1300
  • 3 rows and $700

Answer :3 rows and $700

What is the maximum iterations of previous() allowed by Qlik?


Options are :

  • Previous(Previous(Previous(Previous([Field Name]))))
  • Previous(Previous([Field Name]))
  • Previous([Field Name])
  • Previous(Previous(Previous([Field Name])))

Answer :Previous(Previous(Previous([Field Name])))

Become a Certified QlikView Expert Set 4

What is the output of the following expression in the text box without any selections; when we have two fields in the table with the following values:

=Only(MyRowNum) 


Options are :

  • 0
  • NULL
  • 5
  • 1

Answer :0

What is the difference between Numsum() and Rangesum() functions?


Options are :

  • Numsum doesn't exist
  • Numsum doesn't treat null as 0
  • They are exactly the same
  • Numsum can only be used within the script

Answer :They are exactly the same

Which chart type must be used when creating a mini chart as shown in this example?


Options are :

  • Mekko Chart
  • Bar Chart
  • Radar Chart
  • Straight Table

Answer :Straight Table

Become a Certified QlikView Expert Set 5

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


Options are :

  • The names of the fields to join over must be exactly the same
  • All the statements are TRUE
  • No field in common will render the Cartesian product of the tables
  • Unless a table name of a previously loaded table is specified in the join statement the join prefix uses the last previously created table
  • The number of fields to join over is arbitrary

Answer :All the statements are TRUE

Which of the following objects use dimension(s) and group the expression per dimension value?


Options are :

  • Pivot Table
  • Straight Table
  • Gauge Chart
  • Bar Chart
  • Pie Chart
  • Text Box

Answer :Pivot Table Straight Table Bar Chart Pie Chart

Is "Where Exists(FieldA) and Exists(FieldB)" from a QVD optimised?


Options are :

  • Yes
  • No

Answer :No

While you design a sheet in QlikView 12.1, you have a list box which has "LED Checkbox" styling. And the field name is OrderDate. Your manager wanted this field to have always ONE value selected. You realized you can use - "Always One Selected Value" in List Box properties. However, this option is not enable to check. Why do you think it is not enabled?


Options are :

  • This property has been deprecated in QlikView 12.1 version hence it is not available
  • OrderDate does not have distinct values and this property "Always Ine Selected Value" is not available when field values are not DISTINCT
  • OrderDate is the key field and "Always One Selected Value" is not available for the key field(s)
  • There is no active selection or more than one field value is selected in the OrderDate Field

Answer :There is no active selection or more than one field value is selected in the OrderDate Field

You have recently joined SmartCars as a QlikView Developer. SmartCars has a junior Developer who is struggling to fix bugs in the below code. You need to code review and identify total number of bugs which includes syntax and logical errors in the below script. 

Expected output must have two table: Emp1 and Emp3 with the following results and data model. 

Script

Output Result:



Output Data Model:




Options are :

  • 3 bugs
  • 2 bugs
  • 5 bugs
  • 4 bugs

Answer :4 bugs

What is the result in Internal Table View under Table Viewer of the following after reloading the below script:



Options are :

  • 2 Tables 3 Fields
  • 2 Tables 1 Synthetic Table 3 Fields
  • 2 Tables 1 Synthetic Table 5 Fields
  • 1 Table 3 Fields

Answer :2 Tables 1 Synthetic Table 3 Fields

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions