The Multi Box
by Karl Pover, Stephen Redmond, Barry Harmsen, Miguel Angel Garcia
QlikView: Advanced Data Visualization
- QlikView: Advanced Data Visualization
- Table of Contents
- QlikView: Advanced Data Visualization
- Contributors
- Preface
- 1. Performance Tuning and Scalability
- Reviewing basic performance tuning techniques
- Generating test data
- Understanding how QlikView stores its data
- Strategies to reduce the data size and improve performance
- Testing chart performance for different load options
- Optimizing chart calculation times
- The QlikView calculation engine
- Using Direct Discovery
- Testing scalability with JMeter
- Running an example execution
- Summary
- 2. QlikView Data Modeling
- Reviewing basic data modeling
- Dimensional data modeling
- Differentiating between facts and dimensions
- Understanding the grain
- Understanding star schemas
- Summing with facts
- Discovering more about facts
- Dealing with nulls in fact tables in QlikView
- Designing dimension tables
- Defining Kimball's four-step dimensional design process
- Learning some useful reusable dimension methods
- Creating dimensional facts
- Handling slowly changing dimensions
- Dealing with multiple fact tables in one model
- Drilling across with document chaining
- Summary
- 3. Best Practices for Loading Data
- Reviewing data loading concepts
- Understanding why you should use an ETL approach
- Using an ETL approach to create QVD data layers
- Mastering loading techniques
- Using QlikView Expressor for ETL
- Summary
- 4. Advanced Expressions
- Reviewing basic concepts
- Understanding Dollar-sign Expansion
- Using advanced Set Analysis
- Calculating vertically
- Summary
- 5. Advanced Scripting
- Reviewing the basic concepts
- Counting records
- Loading data quickly
- Applying variables and the Dollar-sign Expansion in the script
- Using control structures
- Examining advanced Table File Wizard options
- Looking at data from different directions
- Reusing code
- Summary
- 6. What's New in QlikView 12?
- 7. Styling Up
- 8. Building Dashboards
- User types
- Applying the DAR principle to Airline Operations
- Creating the Analysis sheet
- Creating the new Dashboard sheet
- Creating the Reports sheet
- Other charts
- Summary
- 9. Advanced Data Transformation
- 10. Security
- 11. Data Visualization Strategy
- 12. Sales Perspective
- 13. Financial Perspective
- 14. Marketing Perspective
- 15. Working Capital Perspective
- 16. Operations Perspective
- 17. Human Resources
- 18. Fact Sheets
- 19. Balanced Scorecard
- 20. Troubleshooting Analysis
- 21. Mastering Qlik Sense Data Visualization
- Index
While listboxes are a very convenient way to quickly make selections, the downside is that they can also take up a lot of space. This is where the multi box offers an alternative. The multi box displays each field on a single line, alongside a drop-down that expands to allow selections to be made.
Let's add a multi box that contains some extra information on flights, by following these steps:
- Select Layout | New Sheet Object | Multi Box….
- In the Title input field enter
Flight Information. - From the list of Available Fields, double-click the fields From – To City, Origin City, Origin Country, Destination City, Destination Country, and Distance Interval.
- Go to the Sort tab and select Distance Interval from the list of Fields.
- In the Sort by section, uncheck the Text option, and mark the Load Order checkbox.
- Click on OK to apply the settings and close the Multi Box Properties page.
The resulting multi box should look like the one shown in the following screenshot. Notice how the list of values is expandable when clicking on each field. Also note that the sort order for the Distance Interval is no longer alphabetical, but uses the order in which the values were loaded into QlikView:
During this exercise, you may have noticed that, unlike the listbox, the Sort tab for the multi box contains multiple fields and that we can set different sort orders for each field. This is also the case for the alignment options on the Presentation tab and the number format options on the Number tab. This is not only true for multi boxes, but for any object that contains multiple dimensions and/or expressions, such as table boxes and charts.
-
No Comment