Learn By Example: Qlikview [Video]

Preview in Mapt

Learn By Example: Qlikview [Video]

Loonycorn

An all-round toolkit to play with data
Mapt Subscription
FREE
$29.99/m after trial
Video
$41.65
RRP $48.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$41.65
$29.99p/m after trial
RRP $48.99
Subscription
Video
Start 30 Day Trial

Frequently bought together


Learn By Example: Qlikview [Video] Book Cover
Learn By Example: Qlikview [Video]
$ 48.99
$ 41.65
Learning QlikView® 12 [Video] Book Cover
Learning QlikView® 12 [Video]
$ 124.99
$ 106.25
Buy 2 for $35.00
Save $138.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Video Details

ISBN 139781788834391
Course Length2 hours 47 minutes

Video Description

Qlikview : One tool to Transform, Summarize and Visualize Data

A Qlikview app is like an in-memory database. The interactive nature of Qlikview allows you to explore and iterate very quickly to develop an intuitive feel for your data.

What's covered in this course are as follows - The Qlikview In-memory data model, Use List boxes, Table boxes and Chart boxes to query data, Load data into a QV app from CSV and Databases, avoiding Synthetic keys and Circular references, Transform and adding new fields in a Load script, Transform tables with Join, Keep, Effectively present your insights using elements like charts, drill downs, triggers, Nested aggregations in charts, Generic Loads, Mapping Loads, Crosstable.

Style and Approach

A small course of 3 hours on Qlikview – in memory database to create an application.

Table of Contents

Introduction
You, This Course and Us
Getting Started
Understanding a Qlikview Document
The In-Memory Data Model
Installing the Qlikview Desktop Client
Loading Data into a QV App
Loading data from a CSV file
Loading data from a Database
Avoiding Synthetic Keys
Removing Circular References
Exploring Data using the UI
List Boxes are like Select DISTINCT
Table boxes are for Selecting columns
Selection interactions in QV
Summarizing data with Chart Boxes
Data Types in QV : The Dual Format Representation
Transforming Data in Load Scripts
Adding calculated fields in the load script
Using a variable in the load script
Joining tables in memory
The Keep keyword
Loading data from in-memory tables
Inline loads
Effectively presenting data
Some useful dashboard elements
Grouped Fields
Highlighting with Color
The total keyword
Using Set analysis to override selections
Advanced Load Transformations
Mapping Loads
Generic Load
Appendix

What You Will Learn

  • Build Qlikview apps end-to-end from loading to visualization
  • Load data from sources like CSVs and Databases
  • Transform data using Joins and Keep
  • Run queries using List boxes and Chart boxes
  • Visualize data with Charts, Drill downs and Triggers

Authors

Table of Contents

Introduction
You, This Course and Us
Getting Started
Understanding a Qlikview Document
The In-Memory Data Model
Installing the Qlikview Desktop Client
Loading Data into a QV App
Loading data from a CSV file
Loading data from a Database
Avoiding Synthetic Keys
Removing Circular References
Exploring Data using the UI
List Boxes are like Select DISTINCT
Table boxes are for Selecting columns
Selection interactions in QV
Summarizing data with Chart Boxes
Data Types in QV : The Dual Format Representation
Transforming Data in Load Scripts
Adding calculated fields in the load script
Using a variable in the load script
Joining tables in memory
The Keep keyword
Loading data from in-memory tables
Inline loads
Effectively presenting data
Some useful dashboard elements
Grouped Fields
Highlighting with Color
The total keyword
Using Set analysis to override selections
Advanced Load Transformations
Mapping Loads
Generic Load
Appendix

Video Details

ISBN 139781788834391
Course Length2 hours 47 minutes
Read More

Read More Reviews

Recommended for You

Learning QlikView® 12 [Video] Book Cover
Learning QlikView® 12 [Video]
$ 124.99
$ 106.25
Kotlin Programming By Example [Video] Book Cover
Kotlin Programming By Example [Video]
$ 124.99
$ 106.25
JavaScript by Example [Video] Book Cover
JavaScript by Example [Video]
$ 124.99
$ 25.00
OpenCV 3 by Example [Video] Book Cover
OpenCV 3 by Example [Video]
$ 124.99
$ 106.25
Django by Example [Video] Book Cover
Django by Example [Video]
$ 124.99
$ 106.25
Unity 5.x by Example [Video] Book Cover
Unity 5.x by Example [Video]
$ 124.99
$ 106.25