QlikView: Creating Line Charts, Combo Charts, Pivot Tables, & Block Charts

QlikView 12.5    |    Beginner
  • 12 videos | 1h 44m 45s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
At QlikView's core is a patented associative engine allowing for an associate experience across data types regardless of where they're stored. In this course, you'll explore how to use your time-series data to build line charts. You'll then customize these charts in various ways, such as using smoothing techniques to represent approximations or multiple lines to demonstrate values in more than one variable. Next, you'll configure stacked area charts to visualize the composition of variables over time before using combo charts to visualize multiple chart types on the same axes. Finally, you'll examine how you can explore hierarchical data using pivot tables and block charts. You'll identify the differences between pivot tables and straight tables and distinguish how each of these represents underlying data.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Use qlikview to create and format a line chart
    Perform regression analysis using trendlines
    Create various customized line charts and explore the use of stacked area charts
    Create basic combo charts with bars and lines
    Customize combo charts by adding labels and lines
  • Explore the use of stacked bar charts
    Use a pivot table to access aggregate values in hierarchical data
    Combine a straight table with a pivot table and access currently selected data
    Create a treemap, also called a block chart, to visualize hierarchical data
    Create a donut chart and use buttons to perform operations on data
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 56s
    Advance your skills in QlikView by learning how to construct advanced chart types and apply advanced configuration options. Choosing the best visualization type gives you the most options when creating and configuring the charts or tables. Different chart types often work better to display certain types and amounts of data, so selecting the best option upfront lets you make the most enhancements as you work.  FREE ACCESS
  • 10m 51s
    Discover how you can do more with visualizations in QlikView when you use line charts to show continuous data, or data over time. You’ll go even further by being introduced to creating, formatting, and configuring line charts. FREE ACCESS
  • Locked
    3.  Applying Regression Using QlikView Trendlines
    8m 34s
    In this video, learn how to create and configure Trendlines in QlikView. When working with Trendlines, you'll need to analyze the line charts to create the trendlines in order to perform regression analysis. Data trends are an important part of working with line charts and trends offer lots of options at the configuration screens.  FREE ACCESS
  • Locked
    4.  Customizing Line Charts & Using QlikView Area Charts
    9m 38s
    Continue advancing your ability to work with line charts in QlikView by practicing how to create them and also by exploring the many customization options of line charts. Get ready to begin exploring the area chart visualization option and to learn how it offers certain advantages over line charts. FREE ACCESS
  • Locked
    5.  Creating Standard Combo Charts in QlikView
    10m 55s
    Learn why choosing an area chart to visualize data in QlikView is more challenging than choosing another type of chart but also understand their benefits. Experienced data analysts recognize that area charts are more challenging to create and configure than line charts; but they also know once you learn and see the benefits that area charts offer, you'll learn it far outweighs any challenges. FREE ACCESS
  • Locked
    6.  Customizing Combo Charts in QlikView
    10m 15s
    Dig into what makes combo charts a great option for data visualizations and the skills you need to create them in QlikView. There are lots of ways to customize the properties of a combo box, including using different appearances which results in giving the audience even more ways to analyze the data and gather useful and valuable insights. FREE ACCESS
  • Locked
    7.  Create Stacked Bar Charts in QlikView
    9m 3s
    Gain the skills you need to add stacked bar charts to data visualizations in QlikView. To make sure your graphic elements are visually successful and functionally useful, you must also understand when to choose the stacked bar chart over the other chart types available to you.  FREE ACCESS
  • Locked
    8.  Visualizing Hierarchical Data Using Pivot Tables
    10m 42s
    Explore the logic of pivot tables to learn what makes them so powerful and how to harness that power and put it work for you when creating data visualizations in QlikView. Visualizing hierarchical data and accessing aggregate values are two examples of how to use pivot tables to provide options for data analysis manipulation and analysis that other charts may not be able to offer. FREE ACCESS
  • Locked
    9.  Using Selected Data & QlikView Straight/Pivot Tables
    10m 58s
    Find out why QlikView’s associative model lets you use a straight table combined with a pivot table to create a new and powerful analysis tool. When you understand straight tables and how they are alike and not alike pivot tables, you should move on to letting the powerful combination chart offer innovative ways to visualize data. FREE ACCESS
  • Locked
    10.  Visualizing Hierarchies Using QlikView Block Charts
    10m
    Explore and understand why, when, and how to create and configure treemaps that will visualize hierarchical data in QlikView. A treemap is also referred to as a block chart so you should relate to both terms interchangeably. Block charts can be quickly created and customized to meet your data analysis needs. FREE ACCESS
  • Locked
    11.  Creating Buttons in QlikView
    9m 47s
    Advance your abilities to create and customize useful block charts in QlikView visualizations when you learn to add a corresponding donut chart and buttons to it. When they're clicked, buttons will perform specific actions that you assign to them, so you also must understand different action types and some basic selection actions. FREE ACCESS
  • Locked
    12.  Course Summary
    2m 5s
    Review how to create and customize different chart and table types in QlikView and how to pick a type that works best with the specific data. Learn the importance of selecting the right chart or table. Explore basic must-know logics and terms related to data analytic visualizations. Review specific skills to help you work smarter by giving you the ability to improve on the usefulness and value of the associative experience available in your dashboards. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Analyzing tables & customizing charts in Sheets 2022
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Course Setting up the Data Infrastructure in an Organization
Rating 4.4 of 39 users Rating 4.4 of 39 users (39)
Course Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Rating 4.6 of 150 users Rating 4.6 of 150 users (150)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Course Building Trust with Business Ethics
Rating 4.5 of 1889 users Rating 4.5 of 1889 users (1889)