MCQs on Basic Visualizations | Qlikview MCQ Questions
Master the fundamentals of creating effective visualizations in QlikView. Learn about bar, line, and pie charts, list boxes, filters, and how to customize visualizations using dimensions and measures.
Creating Charts (Bar, Line, Pie)
- Which of the following charts is best suited for displaying trends over time in QlikView?
a) Bar chart
b) Line chart
c) Pie chart
d) Scatter plot - What is the primary use of a pie chart in QlikView?
a) To display hierarchical data
b) To represent parts of a whole
c) To show trends over time
d) To compare multiple datasets - In QlikView, which chart is ideal for comparing quantities across categories?
a) Line chart
b) Pie chart
c) Bar chart
d) Radar chart - When adding a chart in QlikView, what is the first step?
a) Select a chart type
b) Add data
c) Choose a color scheme
d) Define dimensions and expressions - Which property in QlikView allows you to switch between chart types like bar, line, and pie?
a) Chart Builder
b) Chart Wizard
c) Chart Properties
d) Chart Settings
Creating List Boxes, Text Boxes, and Filters
- What is the purpose of a List Box in QlikView?
a) To display key performance indicators
b) To allow users to filter data based on a specific field
c) To create custom calculations
d) To group multiple fields - In QlikView, how do you add a Text Box to a sheet?
a) Use the “Text & Image” option
b) Right-click and select “Add Text Box”
c) Use the “Add Chart” menu
d) Drag a field into the workspace - Which of the following elements is NOT customizable in a Text Box in QlikView?
a) Font style
b) Background color
c) Border thickness
d) Data calculations - How can filters be applied in QlikView?
a) By selecting values in a List Box
b) By applying a dynamic query
c) By editing script syntax
d) By using pivot tables - What happens when you clear a filter in QlikView?
a) The associated data is removed from the chart
b) All previously selected data is restored
c) The app refreshes its data model
d) Nothing changes
Using Dimension and Measure Fields
- What is a dimension in QlikView?
a) A field used for aggregation calculations
b) A descriptive field used for grouping and categorizing data
c) A filter for raw data
d) A type of chart property - Which of the following fields can be used as a dimension?
a) Sales amount
b) Customer name
c) Total revenue
d) Average score - What is a measure in QlikView?
a) A field used to group data
b) A calculated value used for analysis
c) A property of a chart
d) A script used for data transformations - In QlikView, which of the following functions can be used to create a measure?
a) COUNT
b) IF
c) SUM
d) All of the above - How do dimensions and measures interact in QlikView visualizations?
a) Dimensions define the structure, and measures calculate the values
b) Measures categorize data, and dimensions calculate values
c) Both are interchangeable in charts
d) Neither impacts visualizations directly
Sorting and Customizing Visualizations
- Which of the following options allows you to sort data in QlikView charts?
a) Chart Type Settings
b) Sort Tab in Chart Properties
c) Data Load Editor
d) Script Variables - How can you sort a bar chart by numerical values in QlikView?
a) Use alphabetical sorting
b) Use the “Sort by Y-Value” option
c) Apply custom scripting
d) Manually reorder data - What is the primary benefit of sorting data in QlikView visualizations?
a) Faster data loading
b) Enhanced user understanding and insights
c) Reduced memory usage
d) Improved script execution - In QlikView, what does the Presentation tab in chart properties allow you to do?
a) Customize colors and fonts
b) Add calculated dimensions
c) Define sorting rules
d) Configure data load options - Which of the following customization options is available for bar charts in QlikView?
a) Change bar width
b) Add gradient colors
c) Show/hide data values on bars
d) All of the above
Advanced Chart Features in QlikView
- Which feature in QlikView allows you to add multiple dimensions in a single chart?
a) Drill-down groups
b) Linked dimensions
c) Master items
d) Layered fields - How can you enable conditional formatting in a QlikView chart?
a) By applying an expression in the “Visual Cues” tab
b) By changing the data script
c) By editing the dimension properties
d) By using pivot tables - What is the purpose of cyclic groups in QlikView?
a) To filter data dynamically
b) To enable switching between multiple dimensions in a chart
c) To create hierarchical structures
d) To calculate moving averages - How can you add a title to a QlikView chart?
a) Use the Presentation tab in Chart Properties
b) Edit the chart’s expression
c) Add a Text Box overlay
d) Titles are added automatically - What is the maximum number of dimensions you can add to a QlikView bar chart?
a) 1
b) 2
c) 5
d) Unlimited
Interactive Features and Filters
- How can you enable drill-down in QlikView visualizations?
a) By creating a drill-down group in the Dimensions tab
b) By enabling it in the Data Load Editor
c) By using advanced scripting
d) By adding custom filters - What happens when you click on a dimension value in a QlikView chart?
a) The chart refreshes to show related data
b) The dimension value is removed from the chart
c) The dataset is deleted
d) The visualization resets - Which visualization feature in QlikView helps you highlight specific data points?
a) Custom coloring
b) Expression highlighting
c) Advanced scripting
d) Filtering - How can you export a QlikView chart to Excel?
a) Right-click the chart and select “Export”
b) Save it directly from the Data Load Editor
c) Use the Script Editor
d) Exporting is not possible - Which feature ensures interactive filtering in QlikView visualizations?
a) Associative model
b) Pivot tables
c) Master measures
d) Drill-through
Answer Key
| Qno | Answer |
|---|---|
| 1 | b) Line chart |
| 2 | b) To represent parts of a whole |
| 3 | c) Bar chart |
| 4 | a) Select a chart type |
| 5 | c) Chart Properties |
| 6 | b) To allow users to filter data based on a specific field |
| 7 | b) Right-click and select “Add Text Box” |
| 8 | d) Data calculations |
| 9 | a) By selecting values in a List Box |
| 10 | b) All previously selected data is restored |
| 11 | b) A descriptive field used for grouping and categorizing data |
| 12 | b) Customer name |
| 13 | b) A calculated value used for analysis |
| 14 | d) All of the above |
| 15 | a) Dimensions define the structure, and measures calculate the values |
| 16 | b) Sort Tab in Chart Properties |
| 17 | b) Use the “Sort by Y-Value” option |
| 18 | b) Enhanced user understanding and insights |
| 19 | a) Customize colors and fonts |
| 20 | d) All of the above |
| 21 | a) Drill-down groups |
| 22 | a) By applying an expression in the “Visual Cues” tab |
| 23 | b) To enable switching between multiple dimensions in a chart |
| 24 | a) Use the Presentation tab in Chart Properties |
| 25 | c) 5 |
| 26 | a) By creating a drill-down group in the Dimensions tab |
| 27 | a) The chart refreshes to show related data |