- Introduction to Qlikview Overview
- Qlikview Desktop
- Object-Insert and Object Properties in Dashboard
- File Wizard: Transform–Basic Transformation in Qlikview
- Create Select Statement
- Dashboard Sheet
- Chart Properties & Scripting
- Security & Access Types
- Explain Table, Dimensions, Metrics & Pivot Table
- Use of Temporary Tables & Explain Set Analysis Its Syntax and Why it is Used
- QMC, Server and Document Distribution
1. Introduction to Qlikview Overview
- Patented In-Memory Associative Technology-What, How and The Power of simplicity
- Representing Qlikview Solutions by Function
- Architecture Overview-Diff b/w server and publisher
- Qlikview Platform Overview
- Products Overview-Qlikview Developer, Server and Publisher
- What can you do with Qlikview? The sum of Five Capabilities which make Qlikview Unique
- 3 Kinds of Roles-Qlikview and the IT Pro, Qlikview and the Business Analyst/BI Developer, Qlikview and the Business User
- Benefits of using Qlikview
2. Qlikview Desktop
- Describe Table-Fields, Name
- QVD File-Qlikview Data File
- How to create qvd file-By only Qlikview Desktop
- File Wizard: Options
- File Wizard:Transforms
- QVD only 90 MB, compress 90%, take GB of Data
- Color in Qlikview and their relation to data Green-selected data, Gray-Non Associated, White-Associated. Power of Associatively
- How Qlikview works
3. Object-Insert and Object Properties in Dashboard
- Load QVD file
- Internal Table View
- Object-insert and object properties in dashboard
- New search object
- Associated data, non-associated data
- Clear the selection-automatically and manually both type
- Sort data in list box properties
- Document properties
- Create bar chart-in chart y axes-expression axes, x axes-dimension axes, chart properties
- Group-2 types-Drill Down, Cyclic
- Graph-Chart Properties
- Setting-Variable overview-add variable
- Input box properties
- Load data from access database
- Connections-2 types-ODBC, OLEDB
- Use QlikView as reporting tool
- Create select statement
4. File Wizard: Transform–Basic Transformation in Qlikview
- Add data from CSV and Excel
- File Wizard: Type
- Quoting Types
- File Wizard: Transform- Basic Transformation in Qlikview
- Transformation Step
- Conditional Delete
- Fill Condition
- Specify Row Condition
- Unwrap Function
- Rotate Function
- Difference b/w Transpose and Left
- File Wizard: Script
- Inline Table-create inline table
- Internal Table View
- Dashboard Background-3 Regions
- Document Properties-General, Opening, Sheets, Server, Scheduler, Variables, Security, Triggers, Groups, Tables, Sort, Presentation, Number, Scrambling, Extensions, Font, Layout, Caption
- Chart Properties
- Format Painter Tool
- List Box Properties
- User Preferences-General, Save, Editor, Design, Objects, Font, Expert, Printing, Mail, Locations,Security-Macro, License
- Tools-Alert
- Sheet Properties
- Expression Overview
- Objects-Current Selection Box, New Statistics Box, New Button Object
5. Create Select Statement
- Connection String
- Select Statement: Create select statement
- Problem Discussion
- Fact Table-Explain
- Load Statement
6. Dashboard Sheet
- Dashboard created based on 3 principles-DAR
- Dashboard Sheet
- Analysis Sheet, Analysis Report
- Sheet Properties
- Object-Create Analysis Chart, Chart Properties, Minimize Chart
- Object-Container-new container, container properties, container types
- Linked Objects
- List Box Properties
- Different types of Chart–Scatter Chart, Bubble Chart, Gray Chart, Line Chart, Bar
- Chart, Pie Chart
- Object-Text Object-New Text Object-Text Object Properties
- Market Share
- Dimension Limit Tab-new feature in version 11
- New Input Box
- Object-New Sheet Object-Bookmark Object
- Report-Report Editor, Report Settin
7. Chart Properties & Scripting
- Chart Properties
- Different types of Chart-Radar Chart, Maco Chart, Grid Chart, Funnel Chart
- New Sheet Object-Chart-Block Chart
- Load Statement-Load Inline-Inline Data Wizard
- Match Function
- Scripting
- Load-Aircraft Group, Aircraft Type
- Load-Aircraft Base File
- Editing in Script
- Internal Table View
- Table-Aircraft Group Table, Aircraft Type Table
8. Security & Access Types
- Security
- Concept of Hidden Script, Create Hidden Script
- Security Information-Section Access in Qlikview
- Access types
- Section types
- Hidden Security, Types of Security
- Inline Data Wizard, Load Inline Table
- Section Access Script
- Reduction in Data, Things to make Data Reduction work
- Internal Table View
- Best way to managing the section access & connection strings
- Different Ways to declare variable
- Master Calendar
- Create singular master calendar table
- Different ways to create master calendar, make a temp calendar
- Period Field
- Functions-DATE(), DATE#(), PEEK(), MonthStart(), AutoGenerate(), Quarter(), ceil(), Exists(), Aggregate,InternalMatch()
- Create Aggregated Table
- Transaction Table
9. Explain Table, Dimensions, Metrics & Pivot Table
- Explain Table-Internal Match
- How Qlikview Read Data from Table
- Cross Table-3 Parameters-Qualifier Field, Attribute Field, Data Field
- How to load a cross table
- Explain-Internal Table View
- Operational Metrics, List Box Color
- Load Inline Function: Inline Data Wizard
- Explain Dimension, Metrics, Pivot Table
10. Use of Temporary Tables & Explain Set Analysis Its Syntax and Why it is Used
- Creation of new reports for users
- How to implement set analysis
- Explain the making of line chart
- Explain set theory
- Use of flight domestic foreign carriers
- Explain flight type field
- Search string to find domestic values
- Use of excluded values
11. QMC, Server and Document Distribution
- Discussion & Problem Solve
- QMC-Qlikview Management Console
- Qlikview Server
- Document Distribution