QlikView Course ContentsVersion - 12 What is QlikView? How does QlikView differ from traditional BI Associative user experience Technology Adoption path QlikView Architecture Exploring data with QlikView Getting QlikView Navigating the document Slicing and dicing your data QlikView Menu QlikView Sheet Objects List Box MultiBox Statistics Box Charts Table Box Search Object BookMark Object Slider/Calendar Current Selection Box Line/Arrow Button Text Object Input Box Container Custom Bject System Table Document Properties Sheet Properties User Preference The technology and components behind QlikView The way the data flows When QlikView use expands Create content Reload, publish, and distribute content Consume content Data Sources Loading Data from Excel XML File Flat File Access Database Inline Table QVD's & QVX Uses of QVD Advantage of QVD Charts Bar Chart Line Chart Combo Chart Radar Chart Guage Chart Mekko Chart Pivot Table Straight Table Block Chart Funnel Chart Pie Chart Grid Chart Scatter Chart Waterfall Chart Data Modelling Star Schema Snowflake Schema Associative Data Model Table Viewer Window Table information Field information Table preview Table viewer menu QlikView Scripting The Script Editor Menu and toolbar Script pane Tool pane Data architecture Two-stage architecture Three-stage architecture Setting up our environment Hidden script Section access Section access fields Reduction fields Initial data reduction Omitting fields Document-level security Sheet-level security Summary QV Scripting Synthetic keys Circular Reference Link Table Interval Match Functions - Time , Date, String Resident load The JOIN statement The KEEP statement The CONCATENATE statement The NOCONCATENATE Statement Using MAPPING tables Adding comment Storing tables Renaming tables and fields Deleting tables and fields Setting variables Controlling script flow Conditional functions Dealing with different data types Strings String operators String functions Numbers and numeric functions Date and time functions Master Calendar Loading Cross Table Generic load Binary Load Partial Reload Preceding Load QV Functions Dual Total Aggr Pick Previous Peek Autogenerate class if Set Analysis Point In Time Reporting Alternate states Comparative analysis with alternate states Section Analysis