Join Curt Frye for an in-depth discussion in this video Changing pivot table summaries, part of Up and Running with QlikView.
- When you create a pivot table,…you will usually summarise your data by…finding the sum of a category.…For example, you might want to see…a state's sales by month or perhaps track…the differences among sales on several days of the week.…If you want to view your data…using another summary operation,…such as finding an average, you can do so in a few steps.…I'll show you how to do that in this movie,…and my sample file is the PivotSummary document,…which you can find in the Chapter05 folder…of your Exercise Files collection.…
To change the summary operation for a pivot table…you need to get into its Properties,…so right click the title bar…of the pivot table and click Properties.…Then in the Chart Properties dialogue box…click the Expressions tab and on the right…you can see the definition for the expression…that is used to find the data for the pivot table's body.…Click the ellipse button next to that box,…and you get the EditExpression dialogue box.…
The expression is currently finding…the sum of the order total so what I want to do…
- 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.