Join Curt Frye for an in-depth discussion in this video Creating a pivot table, part of Learning QlikView.
- One of the usual ways…to display your data is in a table,…which is arranged into columns and rows.…Columns represent a single type of data,…such as order numbers or the state…an order came from,…and a row represents a specific order,…and contains a value for each column.…This type of table,…called a Straight Table in QlikView,…is useful for viewing your data.…If you want to rearrange your data dynamically,…though, you need to create a pivot table.…In this movie I will show you…how to create a pivot table…to view your data in a cross tabular format.…
My sample file is the create pivot report,…and you can find it in the chapter five folder…of your exercise files collection.…This report is connected to an outside data source,…and to create my pivot table…I open the Layout menu,…point to New Sheet Object,…and somewhat counter-intuitively,…open the Chart dialogue box.…On the General page of the Chart…dialogue box or Wizard,…click the pivot table icon.…
Doing so identifies that you want…to create a pivot table.…Go ahead and click Next,…
Author
Curt Frye
Released
11/20/2014- 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
Duration
Views
-
Introduction
-
Welcome1m 3s
-
-
1. Introducing QlikView
-
Setting user preferences5m 41s
-
Setting document properties2m 39s
-
Getting help in QlikView2m 35s
-
2. Managing Data Sources and Visualizations
-
Creating a Table box2m 52s
-
Creating a List box3m 35s
-
Creating a Multi box3m 57s
-
Creating a text object5m 17s
-
Creating a container3m 29s
-
3. Managing QlikView Sheets and Files
-
4. Creating Charts and Summaries in QlikView
-
Sorting QlikView data3m 39s
-
Filtering QlikView data3m 35s
-
Creating a chart3m 33s
-
Changing chart properties2m 32s
-
-
5. Creating and Manipulating Pivot Tables
-
Creating a pivot table4m 2s
-
Pivoting a pivot table2m 29s
-
Filtering a pivot table2m 33s
-
Formatting a pivot table3m 37s
-
-
Conclusion
-
Further resources1m 8s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Creating a pivot table