MCQs on Advanced Scripting Techniques | Qlikview MCQ Questions
Enhance your QlikView scripting skills with these 30 multiple-choice questions on advanced ETL operations, set analysis, variables, script control, and debugging techniques for complex QlikView applications.
Advanced ETL Operations
- In QlikView, what is the purpose of the “Concatenate” statement in an ETL process?
- a) To combine fields from different tables into one
- b) To append data from multiple tables into a single table
- c) To split data into separate fields
- d) To perform aggregation
- Which QlikView command is used to load data from a CSV file into the application?
- a) LOAD
- b) SELECT
- c) CONNECT
- d) IMPORT
- How does the “Resident” load operation in QlikView work?
- a) It loads data from an external database
- b) It loads data from a previously loaded table in memory
- c) It loads data from a CSV file
- d) It appends data to a table
- What does the “Drop Table” command do in QlikView?
- a) Deletes a table from the data model
- b) Drops the columns from a table
- c) Clears all data from a table
- d) Renames the table
- What is the function of the “Join” statement in QlikView’s ETL process?
- a) Combines data from different sources into one table
- b) Aggregates data from multiple tables
- c) Filters data based on a condition
- d) Groups data into categories
- Which of the following QlikView commands is used to load a table from an Excel file?
- a) EXCEL LOAD
- b) LOAD FROM XLSX
- c) LOAD * FROM Excel File
- d) No specific command; QlikView automatically handles it
- The “ApplyMap” function in QlikView is used to:
- a) Transform data into different formats
- b) Create new fields based on existing data
- c) Map values from one table to another
- d) Remove duplicates
- What is the purpose of the “Autogenerate” keyword in QlikView scripts?
- a) To generate data from an external source
- b) To create a specified number of records automatically
- c) To load predefined records
- d) To define new fields
- Which command can be used to optimize the ETL process in QlikView by reducing the amount of data loaded?
- a) WHERE
- b) SELECT DISTINCT
- c) Keep
- d) DROP
- What does the “FOR Each” loop do in QlikView scripting?
- a) Iterates over a list of files or values
- b) Executes a conditional statement repeatedly
- c) Loads data based on conditions
- d) Joins multiple data tables
Set Analysis and Data Filtering
- What is the primary purpose of Set Analysis in QlikView?
- a) To aggregate data based on a fixed condition
- b) To manipulate the structure of the data model
- c) To perform advanced data transformations
- d) To join multiple data tables
- Which operator is used in Set Analysis to define the set of values for filtering?
- a) =
- b) =>
- c) $
- d) { }
- In Set Analysis, how do you exclude specific data from a set?
- a) Using the NOT operator
- b) Using the IS operator
- c) Using the AND operator
- d) Using the OR operator
- Which of the following Set Analysis expressions is used to calculate the sum of sales for the current year?
- a) Sum({$<Year = {“2024”}>} Sales)
- b) Sum({$<Year = “2024”>} Sales)
- c) Sum(Sales)
- d) Sum(Sales, Year)
- What does the dollar sign expansion ($) in Set Analysis do?
- a) Expands the current selection context
- b) Filters data based on specific criteria
- c) Defines a fixed condition for the analysis
- d) Converts data into a string format
- How can you use Set Analysis to ignore certain selections?
- a) Using the ignore selection function
- b) Using the $ symbol for dollar sign expansion
- c) By writing an explicit filter condition
- d) Using the exclude keyword
- Which of the following is the correct syntax for using Set Analysis with a date range?
- a) Sum({$<DateField = {“01/01/2023”}>} Sales)
- b) Sum({$<DateField >= “01/01/2023”} Sales)
- c) Sum({$<DateField <= “01/01/2023”} Sales)
- d) Sum({$<DateField = {“01/01/2023…01/31/2023”}>} Sales)
- In QlikView, which symbol is used to reference fields within the Set Analysis expression?
- a) &
- b) $
- c) { }
- d) #
- How can you use Set Analysis to calculate the sum of sales excluding data from a specific product category?
- a) Sum({$<ProductCategory – {“Electronics”}>} Sales)
- b) Sum({$<ProductCategory = {“Electronics”}>} Sales)
- c) Sum({$<ProductCategory <> “Electronics”}>} Sales)
- d) Sum({$<ProductCategory {“Electronics”}>} Sales)
- Which of the following represents a valid Set Analysis expression to get the total sales for the previous year?
- a) Sum({$<Year = {“$Year-1”}>} Sales)
- b) Sum({$<Year = {“2023”}>} Sales)
- c) Sum({$<Year = {“-1”}>} Sales)
- d) Sum({$<Year = {“Previous”}>} Sales)
Variables and Script Control Statements
- What is the role of variables in QlikView scripting?
- a) To store values for dynamic calculation and conditional statements
- b) To transform data during loading
- c) To filter data directly
- d) To generate new data fields
- How do you declare a variable in QlikView?
- a) SET variable_name = value;
- b) VARIABLE variable_name = value;
- c) VAR variable_name := value;
- d) DECLARE variable_name = value;
- In QlikView scripting, which control statement is used to repeat a block of code multiple times?
- a) IF-THEN
- b) FOR EACH
- c) WHILE
- d) CASE
- What is the purpose of the “LET” statement in QlikView scripting?
- a) To define a variable with dynamic values
- b) To assign values to fields in the data model
- c) To load data from external sources
- d) To call external scripts
- What does the “IF” statement in QlikView scripting allow you to do?
- a) Execute code based on a specific condition
- b) Merge tables
- c) Create new fields
- d) Load data from multiple sources
- How can you ensure that a variable’s value can change dynamically in QlikView?
- a) Use the SET statement
- b) Use the LET statement
- c) Use the APPLY function
- d) Use the DO function
- Which of the following is a method to avoid overwriting existing variable values in QlikView?
- a) Use the LET statement
- b) Use the SET statement
- c) Use the IF statement
- d) Use the variable guard
- What does the “EXIT Script” command do in QlikView?
- a) Stops the script execution
- b) Exits the application
- c) Stops data loading
- d) Closes the QlikView session
- In QlikView scripting, which control statement allows you to create a loop that runs indefinitely?
- a) FOR
- b) LOOP
- c) WHILE
- d) REPEAT
- How can you define a condition that checks if a field value is null in QlikView scripting?
- a) IF FieldName = NULL THEN
- b) IF ISNULL(FieldName) THEN
- c) IF NOT FieldName THEN
- d) IF NULL(FieldName) THEN
Answer Key
| Qno | Answer (Option with Text) |
|---|---|
| 1 | b) To append data from multiple tables into a single table |
| 2 | a) LOAD |
| 3 | b) It loads data from a previously loaded table in memory |
| 4 | a) Deletes a table from the data model |
| 5 | a) Combines data from different sources into one table |
| 6 | d) No specific command; QlikView automatically handles it |
| 7 | c) Map values from one table to another |
| 8 | b) To create a specified number of records automatically |
| 9 | a) WHERE |
| 10 | a) Iterates over a list of files or values |
| 11 | a) To aggregate data based on a fixed condition |
| 12 | d) { } |
| 13 | a) Using the NOT operator |
| 14 | a) Sum({$<Year = {“2024”}>} Sales) |
| 15 | a) Expands the current selection context |
| 16 | a) Using the ignore selection function |
| 17 | b) Sum({$<DateField >= “01/01/2023”} Sales) |
| 18 | b) $ |
| 19 | c) Sum({$<ProductCategory <> “Electronics”}>} Sales) |
| 20 | b) Sum({$<Year = {“2023”}>} Sales) |
| 21 | a) To store values for dynamic calculation and conditional statements |
| 22 | a) SET variable_name = value; |
| 23 | b) FOR EACH |
| 24 | a) To define a variable with dynamic values |
| 25 | a) Execute code based on a specific condition |
| 26 | b) Use the LET statement |
| 27 | b) Use the SET statement |
| 28 | a) Stops the script execution |
| 29 | c) WHILE |
| 30 | b) IF ISNULL(FieldName) THEN |