Join Curt Frye for an in-depth discussion in this video Exporting QlikView data to Excel, part of Up and Running with QlikView.
- When you summarize data in QlikView,…you create new temporary data sets.…For example, summarizing sales data by state…would lead you to an entry for each state…and not a table with every individual sale.…Once you've created the summary you want…you can export its contents to an Excel file.…In this movie, I will show you how to do that…using the Export report, and you can find it…in the Chapter03 folder of your Exercise Files collection.…So, let's say that I want to export the…contents of the State list box.…
You can see here that I have a list of states…in alphabetical order and the relative frequency…for orders from each of those states.…I can export the data to Excel…by right-clicking the object's title bar…and then from the shortcut menu, clicking Send to Excel.…Now to have this feature work,…you do need to have Excel installed on your system.…And Excel starts and you can see that…I have the data inside of my worksheet.…I can then save the file and work with data normally.…
I'll go ahead and close out of the workbook.…
- 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.