Introduction
o What Is QlikView?
o About TheOverall Course
o QlikView Basics
Making Queries in QlikView
o Opening the document
o Basic QlikView terminology
o Selections
o Stepping back or forward in the list of
o selections
o Locking and unlocking selections
o Searching values
o Selection bookmarks
o Saving your work
o Checking your work
Handling Sheets & Sheet Objects
o Opening the document
o Sheets
o ogical connections between sheets
o Adding a sheet
o Moving a sheet
o Adding new sheet objects
o Saving, closing and exiting
List Boxes & Statistics Boxes
o Opening the document
o The list box
o The statistics box
o Saving, closing and exiting
Bar Charts & Pie Charts
o Introduction
o Opening the document
o Making selections in a chart
o Changing chart types using a fast type change
o icon
o Creating a bar chart using the Quick Chart
o Wizard
o Creating a bar chart using the full chart wizard
o Removing a chart
o Changing a few properties
o Cloning and detaching your chart
o Turning the bar chart into a pie chart
o Saving, closing and exiting
Pivot Tables & Straight Tables
o Opening the document
o Adding a dimension to a bar chart
o Turning a bar chart into a multidimensional o pivot table o Creating a straight table o Saving, closing and exiting
More Chart Types
o Opening the document
o Creating a line chart
o Adding an expression to a bar chart
o Turning the bar chart into a combo chart
o Turning the combo chart into a scatter chart
o Creating a scatter chart from scratch
o Creating a gauge chart
o Working with drill-down functionality
o Copying to Clipboard and printing
o Saving, closing and exiting
Multi Boxes, Table Boxes and Input
o Boxes
o Opening the document
o The multi box
o The table box
o Using an input box
o Saving, closing and exiting
Buttons, Text Objects And Line/Arrow
o Objects
o Opening the document
o The text object
o The line/arrow object
o The button
o Saving, closing and exiting
Sliders, Current Selection Objects and Bookmark Objects
o Opening the document
o The slider/calendar object (in slider mode)
o Creating a Current Selections box
o Creating a bookmark object
o Saving, closing and exiting
Document Properties, User Preferences & Reload
o Opening the document
o Setting Document Properties
o User Preferences
o Reloading data
o Saving, closing and exiting
o Checking your work
o What's next?
CREATING A DOCUMENT
o Introduction
Loading Data into QlikView
o Looking at a delimited text file
o Creating a new QlikView document
o Loading a text file into QlikView
o Saving, closing and exiting
Associating Data from Many Tables
o Associations
o Opening the document
o Loading and associating a second table
o Renaming fields
o Saving, closing and exiting
Concatenating Tables
o Opening the document
o Automatic concatenation
o Forced concatenation
o Saving, closing and exiting
The Table Structure
o Using the Table Viewer
o Labeling tables in the script
o Improving the layout
o Saving, closing and exiting
Layout Themes
o Creating a theme
o Applying a theme
o Saving, closing and exiting
Loading Additional Files
o Opening the document
o Loading a tab separated file without labels
o Loading a file via OLE DB
o Saving, closing and exiting
Linking External Information to a Document
o Opening the document
o Looking at an info table
o Loading the info table
o Viewing the linked information
o Embedding external info
o Displaying info in a text object
o Saving, closing and exiting
Advanced Features
o Introduction
More about Associations
o Creating a system sheet
o Using the system sheet
o Creating a system table
o Showing frequency in key fields
Load Inline
o Adding a record with load inline
o Adding a table with load inline
Field Groups & Cyclic Display
o Field groups
o Cyclic display of expressions
Loading Cross Tables
o Loading a cross table
o Loading a cross table with more than one
o regular column
And-Mode in List Box
o Making an and-selection
o Making a not selection
o Characteristics of the and table
Number Formats
o Handling of numeric data
o Interpretation of numeric data
o Formatting of data
Security
o Sections in the Script
o Access levels
o Security fields
o Loading security tables
o Using the Security pages
o Opening a document with access restriction
We will provide Live Projects on Qlikview
Yes
If you miss a class we can provide recording video for particular session and same session you have to attend another batch also
Yes
Yes we are giving course completion certificate from Covalent Technologies
Doubts clarification up to getting a job
Resume preparation
Malk interviews
Placement Assistance
It was really a great learning experience in Covalent for Qlikview. The trainer was knowledgeable and conceptual. Being a person from non computer science background concept was explained as understandable to me. Infrastructure is good and made the stay and learning comfortable.
Call us on
