Qlikview Training

Share course

Introduction 

  • What Is QlikView? 
  • About TheOverall Course 
  • QlikView Basics 

Making Queries in QlikView

  • Opening the document 
  • Basic QlikView terminology 
  • Selections 
  • Stepping back or forward in the list of 
  • selections
  • Locking and unlocking selections 
  • Searching values 
  • Selection bookmarks 
  • Saving your work 
  • Checking your work 

Handling Sheets & Sheet Objects 

  • Opening the document 
  • Sheets 
  • Logical connections between sheets 
  • Adding a sheet 
  • Moving a sheet 
  • Adding new sheet objects 
  • Saving, closing and exiting 

List Boxes & Statistics Boxes 

  • Opening the document 
  • The list box 
  • The statistics box 
  • Saving, closing and exiting 

Bar Charts & Pie Charts 

  • Introduction 
  • Opening the document 
  • Making selections in a chart 
  • Changing chart types using a fast type change 
  • icon
  • Creating a bar chart using the Quick Chart 
  • Wizard 
  • Creating a bar chart using the full chart wizard 
  • Removing a chart 
  • Changing a few properties 
  • Cloning and detaching your chart 
  • Turning the bar chart into a pie chart 
  • Saving, closing and exiting 

Pivot Tables & Straight Tables 

  • Opening the document 
  • Adding a dimension to a bar chart 
  • Turning a bar chart into a multidimensional 
  • pivot table 
  • Creating a straight table 
  • Saving, closing and exiting 

More Chart Types 

  • Opening the document 
  • Creating a line chart 
  • Adding an expression to a bar chart 
  • Turning the bar chart into a combo chart 
  • Turning the combo chart into a scatter chart 
  • Creating a scatter chart from scratch 
  • Creating a gauge chart 
  • Working with drill-down functionality 
  • Copying to Clipboard and printing 
  • Saving, closing and exiting 

Multi Boxes, Table Boxes and Input Boxes 

  • Opening the document 
  • The multi box 
  • The table box 
  • Using an input box 
  • Saving, closing and exiting 

Buttons, Text Objects And Line/Arrow 

  • Objects 
  • Opening the document 
  • The text object 
  • The line/arrow object 
  • The button 
  • Saving, closing and exiting 

Sliders Current Selection Objects and Bookmark Objects 

  • Opening the document 
  • The slider/calendar object (in slider mode) 
  • Creating a Current Selections box 
  • Creating a bookmark object 
  • Saving, closing and exiting
  • Document Properties, User 
  • Preferences & Reload 
  • Opening the document 
  • Setting Document Properties 
  • User Preferences 
  • Reloading data 
  • Saving, closing and exiting 
  • Checking your work 
  • What's next? 

CREATING A DOCUMENT 

  • Introduction 
  • Loading Data into QlikView
  • Looking at a delimited text file 
  • Creating a new QlikView document 
  • Loading a text file into QlikView
  • Saving, closing and exiting 

Associating Data from Many Tables 

  • Associations 
  • Opening the document 
  • Loading and associating a second table 
  • Renaming fields 
  • Saving, closing and exiting 
  • Concatenating Tables 
  • Opening the document 
  • Automatic concatenation 
  • Forced concatenation 
  • Saving, closing and exiting 

The Table Structure 

  • Using the Table Viewer 
  • Labeling tables in the script 
  • Improving the layout 
  • Saving, closing and exiting 
  • Layout Themes 
  • Creating a theme 
  • Applying a theme 
  • Saving, closing and exiting 

Loading Additional Files 

  • Opening the document 
  • Loading a tab separated file without labels 
  • Loading a file via OLE DB 
  • Saving, closing and exiting 

Linking External Information to a Document 

  • Opening the document 
  • Looking at an info table 
  • Loading the info table 
  • Viewing the linked information 
  • Embedding external info 
  • Displaying info in a text object 
  • Saving, closing and exiting 

Advanced Features 

  • Introduction 
  • More about Associations 
  • Creating a system sheet 
  • Using the system sheet 
  • Creating a system table 
  • Showing frequency in key fields 

Load Inline 

  • Adding a record with load inline 
  • Adding a table with load inline 

Field Groups & Cyclic Display 

  • Field groups 
  • Cyclic display of expressions 

Loading Cross Tables 

  • Loading a cross table 
  • Loading a cross table with more than one 
  • regular column 
  • And-Mode in List Box 
  • Making an and-selection 
  • Making a not selection 
  • Characteristics of the and table 

Number Formats 

  • Handling of numeric data 
  • Interpretation of numeric data 
  • Formatting of data 

Security 

  • Sections in the Script 
  • Access levels 
  • Security fields 
  • Loading security tables 
  • Using the Security pages 
  • Opening a document with access restriction

 

Key Highlights

 

  • Makemyclass is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time      industry experience.

Makemyclass highlights:

 

  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from Makemyclass who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

 

  • Having 8  years of  IT Industry Experience
  • 6  years  of Qlikview Real Time  Experience
  • Having  3 years experience  as an online trainer for Qlikview
  • Held up to 40+ batches in past 3 years
  • Trainer has an excellent practical & industrial knowledge

Enquiry