QlikView Course Content Introduction
Pivot Tables & Straight Tables
What Is QlikView? About TheOverall Course QlikView Basics
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
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
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?
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad, AP. Ph No: 040 6462 6789, 0998 570 6789 info@kellytechno.com, www.kellytechno.com.
QlikView Course Content CREATING A DOCUMENT
Advanced Features
Introduction
Introduction
Loading Data into QlikView
More about Associations
Looking at a delimited text file Creating a new QlikView document Loading a text file into QlikView Saving, closing and exiting
Creating a system sheet Using the system sheet Creating a system table Showing frequency in key fields
Associating Data from Many Tables
Load Inline
Associations Opening the document Loading and associating a second table Renaming fields Saving, closing and exiting
Adding a record with load inline Adding a table with load inline
Field Groups & Cyclic Display Field groups Cyclic display of expressions
Concatenating Tables Opening the document Automatic concatenation Forced concatenation Saving, closing and exiting
Loading Cross Tables
The Table Structure
And-Mode in List Box
Using the Table Viewer Labeling tables in the script Improving the layout Saving, closing and exiting
Making an and-selection Making a not selection Characteristics of the and table
Loading a cross table Loading a cross table with more than one regular column
Number Formats Layout Themes Creating a theme Applying a theme Saving, closing and exiting
Handling of numeric data Interpretation of numeric data Formatting of data
Security Loading Additional Files Opening the document Loading a tab separated file without labels Loading a file via OLE DB Saving, closing and exiting
Sections in the Script Access levels Security fields Loading security tables Using the Security pages Opening a document with access restriction
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
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad, AP. Ph No: 040 6462 6789, 0998 570 6789 info@kellytechno.com, www.kellytechno.com.