Join Curt Frye for an in-depth discussion in this video Using the New Statistics Box dialog, part of Up and Running with QlikView.
- One of the best ways to summarize your data…is to display some statistics.…For example, you might want to look for the…total number values, the average, the median,…the sum of all values, and so on.…In this report, for example, we might want to find…the sum of all sales.…In this movie, I will show you how to create those…summaries in a compact control…called a Statistics Box.…My sample file is the statistics report,…and you can find it in the chapter four folder…of your exercise files collection.…
So this report at present, contains a number of…list boxes and also a chart.…If I want to add a Statistics Box,…I can go to the Layout menu,…point to New Sheet Object,…and then click Statistics Box.…Doing so displays the New Statistics Box dialogue box.…And the first thing I can do is type a title.…I'll just call it Summary Info.…I typed that here in the Title box.…Next, I need to choose the field that I'm summarizing.…So I'll click the Field control's down arrow,…and I'll click Order Total.…
Next, I can add or remove…
- Installing QlikView
- Setting user preferences and document properties
- Creating visualizations
- Adding objects like List boxes, Multi boxes, and containers
- Adding, deleting, and moving sheets
- Sorting and filtering QlikView data
- Creating charts and pivot tables
Skill Level Beginner
Excel 2013: Managing and Analyzing Datawith Dennis Taylor2h 2m Intermediate
Excel 2013: Data Validation in Depthwith Dennis Taylor1h 5m Intermediate
Excel Data Analysis: Forecastingwith Wayne Winston3h 7m Intermediate
1. Introducing QlikView
2. Managing Data Sources and Visualizations
3. Managing QlikView Sheets and Files
4. Creating Charts and Summaries in QlikView
5. Creating and Manipulating Pivot Tables
Further resources1m 8s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.