MCQs on QlikView Expressions and Functions | Qlikview MCQ Questions
Unlock the power of QlikView expressions and functions with these 30 MCQs. Dive into key topics like aggregation functions, set analysis, calculated dimensions and measures, and conditional formatting for dynamic data analysis.
Using Aggregation Functions (Sum, Count, Avg)
- Which of the following aggregation functions in QlikView calculates the total of a numeric field?
- a) Sum
- b) Avg
- c) Count
- d) Min
- What does the Count() function in QlikView return?
- a) The number of distinct values
- b) The total sum of a field
- c) The number of records or rows
- d) The average value of a field
- In QlikView, which function would you use to calculate the average of a numeric field?
- a) Sum()
- b) Avg()
- c) Count()
- d) Median()
- How does QlikView handle null values when using aggregation functions?
- a) It ignores them in calculations
- b) It replaces them with zeros
- c) It counts them as 1
- d) It throws an error
- Which of the following aggregation functions would be most appropriate to count the number of unique items in a dataset?
- a) Count()
- b) CountDistinct()
- c) Sum()
- d) Avg()
- What would the function Sum(Sales) return in QlikView?
- a) The total of all values in the Sales field
- b) The average of all values in the Sales field
- c) The count of non-null values in the Sales field
- d) The highest value in the Sales field
- Which QlikView function returns the minimum value of a field?
- a) Min()
- b) Max()
- c) Avg()
- d) Sum()
- How do you calculate the total sales for a specific region using aggregation in QlikView?
- a) Sum(Sales) where Region = ‘North’
- b) Sum(Region, Sales)
- c) Count(Sales) where Region = ‘North’
- d) Avg(Sales) where Region = ‘North’
- What function can be used to find the median value in a dataset in QlikView?
- a) Median()
- b) Mode()
- c) Count()
- d) Avg()
- Which aggregation function would you use to get the maximum value in a numeric field in QlikView?
- a) Min()
- b) Max()
- c) Sum()
- d) Count()
Mastering Set Analysis
- What does Set Analysis in QlikView allow you to do?
- a) Perform aggregations based on dynamic selections
- b) Create complex calculated fields
- c) Filter data permanently
- d) Sort the data
- Which syntax is correct for a basic Set Analysis expression in QlikView?
- a) Sum({$<Region=’North’>} Sales)
- b) Sum({Region=’North’}) Sales
- c) Sum({Region=’North’} Sales)
- d) Sum(Sales) where Region=’North’
- In Set Analysis, what does the dollar sign expansion ($) represent?
- a) The current selection state
- b) A specific value
- c) A predefined variable
- d) A fixed set of values
- How would you calculate the total sales for all regions excluding ‘North’ in Set Analysis?
- a) Sum({$<Region-={‘North’}>} Sales)
- b) Sum(Sales) where Region != ‘North’
- c) Sum({Region-={‘North’}} Sales)
- d) Sum({$<Region=’North’>} Sales)
- How would you calculate the sales for the current month using Set Analysis?
- a) Sum({$<Month=Date(Today(), ‘YYYY-MM’)>} Sales)
- b) Sum(Sales) where Month = ‘Current’
- c) Sum({$<Month=’Current’>} Sales)
- d) Sum(Sales) in Month = Date(Today(), ‘YYYY-MM’)
- Which symbol in Set Analysis allows you to perform a union of data sets?
- a) +
- b) &
- c) |
- d) –
- How do you exclude a specific selection from a Set Analysis expression in QlikView?
- a) Use the minus sign (-)
- b) Use the exclamation mark (!)
- c) Use the dollar sign expansion
- d) Use the plus sign (+)
- What is the correct syntax for calculating the total sales where the product is ‘Laptop’ in Set Analysis?
- a) Sum({$<Product=’Laptop’>} Sales)
- b) Sum({Product=’Laptop’}) Sales
- c) Sum(Sales) where Product = ‘Laptop’
- d) Sum({Product=’Laptop’})
- Can Set Analysis be used in QlikView to create historical comparisons?
- a) Yes, using time-based fields in the Set Analysis expression
- b) No, Set Analysis only works for current data
- c) Yes, but only for financial data
- d) No, Set Analysis is not used for comparisons
- Which of the following is a limitation of Set Analysis in QlikView?
- a) It cannot be used with aggregate functions
- b) It does not support dynamic filtering
- c) It cannot be used for complex logic
- d) It cannot reference field values directly
Creating Calculated Dimensions and Measures
- What is a calculated dimension in QlikView?
- a) A dimension created based on an existing field
- b) A dimension created from an expression or formula
- c) A dimension based on aggregated data
- d) A predefined system field
- How do you create a calculated measure in QlikView?
- a) By using the “Expression” field in the Measure section
- b) By using the “Data” section in the script editor
- c) By applying the Set Analysis function to a measure
- d) By concatenating fields
- Which of the following expressions can be used to create a calculated measure in QlikView?
- a) Sum(Sales * Tax)
- b) Sum(Total Sales)
- c) Avg(Price)
- d) Count(CustomerID)
- How would you create a new calculated dimension that groups sales into ‘High’, ‘Medium’, and ‘Low’?
- a) If(Sales > 1000, ‘High’, If(Sales > 500, ‘Medium’, ‘Low’))
- b) Sum(Sales > 1000)
- c) Count(Sales > 500)
- d) Avg(Sales > 1000)
- Which of the following functions can be used to create a calculated dimension based on a time range in QlikView?
- a) Date()
- b) If()
- c) Year()
- d) All of the above
- What is the advantage of using calculated measures in QlikView?
- a) They allow for dynamic aggregation based on selections
- b) They reduce data storage requirements
- c) They can only be used in tables
- d) They improve performance by simplifying data
- How do you format a calculated dimension or measure in QlikView?
- a) Use the “Number Formatting” option
- b) Format it in the script editor
- c) Use CSS for styling
- d) Use Set Analysis for formatting
- How can you handle null values when creating calculated dimensions or measures?
- a) Use the If() function to replace null values
- b) Ignore null values
- c) Replace null values with zeros
- d) Both a and c
- Can you use a calculated dimension in a QlikView chart?
- a) Yes, as a regular dimension
- b) No, only as a filter
- c) Yes, but only in table charts
- d) No, calculated dimensions are not allowed
- How would you display the total sales for the top 5 products using a calculated measure in QlikView?
- a) Sum(Total Sales) where Rank(Product) <= 5
- b) Sum(Sales) where Product in Top 5
- c) Sum(Sales) using the Rank() function
- d) Sum(Sales) where Product in ‘Top 5 Products’
Answer Key
| Qno | Answer (Option with Text) |
|---|---|
| 1 | a) Sum |
| 2 | c) The number of records or rows |
| 3 | b) Avg() |
| 4 | a) It ignores them in calculations |
| 5 | b) CountDistinct() |
| 6 | a) The total of all values in the Sales field |
| 7 | a) Min() |
| 8 | a) Sum(Sales) where Region = ‘North’ |
| 9 | a) Median() |
| 10 | b) Max() |
| 11 | a) Perform aggregations based on dynamic selections |
| 12 | a) Sum({$<Region=’North’>} Sales) |
| 13 | a) The current selection state |
| 14 | a) Sum({$<Region-={‘North’}>} Sales) |
| 15 | a) Sum({$<Month=Date(Today(), ‘YYYY-MM’)>} Sales) |
| 16 | b) & |
| 17 | a) Use the minus sign (-) |
| 18 | a) Sum({$<Product=’Laptop’>} Sales) |
| 19 | a) Yes, using time-based fields in the Set Analysis expression |
| 20 | d) It cannot reference field values directly |
| 21 | b) A dimension created from an expression or formula |
| 22 | a) By using the “Expression” field in the Measure section |
| 23 | a) Sum(Sales * Tax) |
| 24 | a) If(Sales > 1000, ‘High’, If(Sales > 500, ‘Medium’, ‘Low’)) |
| 25 | d) All of the above |
| 26 | a) They allow for dynamic aggregation based on selections |
| 27 | a) Use the “Number Formatting” option |
| 28 | d) Both a and c |
| 29 | a) Yes, as a regular dimension |
| 30 | a) Sum(Total Sales) where Rank(Product) <= 5 |