QlikView Server and Publisher

Explore how QlikView loads entire datasets into RAM and uses an associative engine to reveal insights through on-the-fly aggregations and data visualizations without pre-aggregated cubes.

Learn who QlikTech is and how QlikView and Qlik Sense offer visual business intelligence and data discovery, challenging traditional BI and earning a leadership position in Gartner's Magic Quadrant.

Explore the QlikView server and publisher architecture, including the desktop, server, and publisher components, data sources, document reload, and front-end load balancing.

Discover the QlikView product family and three roles—administrator, developer, and user—covering the server, publisher, and QMC, and how desktop builds data models and published apps for access via Access Point.

Explore QlikView server and publisher components, including the in-memory Cuvee engine, server security and clustering, and the publisher's data loading and distribution to access point users.

Explore QlikView's mobile and web clients, including plug-in and ajax options, delivering live data, collaboration, and an associative experience across devices.

Explore clickthrough workbench and extensions to build custom charts with HTML, JavaScript, and CCIS, learn licensing and printing and connectors basics, including the slope chart.

Explore QlikView deployment fundamentals, from the data layer and connectors to content creation, publishing with server and publisher, and user access via the access point and clients, with layered security.

Explore four deployment options for QlikView: personal edition, standalone, single-node, and cluster deployments, and learn how licenses, server access, and security like section access influence scalability and data sharing.

Explore deploying QlikView without publisher, using manual server deployment and the reload engine to fetch data via connection strings, with integrated Windows authentication for access.

Learn deployment fundamentals for QlikView, from the data layer and connectors to content phases and deployment options, including publisher role, access point, and security.

Compare three development methodologies and learn when to use single tier architecture, which loads data directly from the source, offering fast reloads but higher network load and possible inconsistencies.

Compare two-tier architecture where a covid builder extracts data from source tables into a covid file, stores dimensions in the dimension folder and facts in the cube folder.

Explore tier three architecture, where the transformed cubed layer contains business logic, enabling faster, optimized loads and improved data consistency in the presentation layer.

Examine tier one, tier two, and tier three development methodologies in QlikView, focusing on how data loads, cubed files, and transformer cuvee w affect performance, consistency, and security.

Learn the fundamentals of service oriented architecture and the role of Cliffview services, their inter-service communication via QIP and web services, and front-end versus back-end deployment.

Explore the QlikView server service (QVS) and its companion services for distribution, directory, web server, and settings, and learn client–web server–cube communication, caching behavior, and the Tulip encrypted binary protocol.

Explore how the QDS distribution service powers reloads and end-user rendering with publisher licenses, static and dynamic data reduction, and section access in multi-node deployments.

Introduce the directory service connector (DSC), which retrieves end-user information from active directory held up or EBC and custom users, and supports license management in UMC.

Understand the role of the QlikView Management Service as the administration entry point and how Kuepper stores and backs up settings in XML or a database.

The QlikView web server can operate standalone or behind IIS, while the setting service manages calls; Access Point hosts pages, enabling load balancing and client connections via WPX and QIP.

Create and configure a dedicated service account to install the server, run its services, and grant membership to the local administrators group to launch the management console.

Learn how to perform a step-by-step installation of QlikView server using a service account, covering region, license agreement, install location, and validating credentials.

Configure the QlikView environment by setting the click management service, mounting user documents, tuning the working set and inactive session time, and enabling logs for governance.

Explore how to view QlikView event logs using the Windows event viewer, filter by source and level, and configure log locations, verbosity, and daily log file splitting.

Learn to load and analyze QlikView event logs in the server management console, extract message types via subfield splitting, and observe real-time updates as verbosity settings reveal detailed info.

Analyze performance logs to track memory statistics, sessions, and documents loaded per interval in KMC. Correlate with event and session logs to diagnose server starts, stops, and memory metrics.

Explore end-user audit logs, showing who used which sheets and bookmarks, what actions they took, and how enabling audit logging in KMC aids troubleshooting and usage analysis.

Explore how to locate and interpret the directory service connector and web server logs in QlikView server to troubleshoot Active Directory connectivity and client requests.

Explore the QMC tour for QlikView server and publisher, mastering the status, tasks, and services tabs, and understand source documents, published documents, and active user monitoring.

Learn how to use loop and reduce in QlikView publisher to create document instances for each field value or bookmark, with examples like beverages by category and country-based reductions.

Learn how IDEX triggers enable event-driven task starts by pushing external events to the click through management service, including setup, configuration, and running a trigger via executable and config.

Enable collaborative sessions on the QlikView server to share documents in real time. Users without licenses can join via a one-time URL and interact bidirectionally with the document.

See how data lineage maps data from source to the presentation layer. Schedule triggers and dependencies so the presentation layer runs only after the covid builder completes.

Troubleshoot QlikView services by verifying all services are running, starting the management service, and using event and distribution logs to restore KMC, UMC, and access point quickly.

Explore how to manage tasks in QlikView server and publisher, using task and document logs, filters, and orphan tasks when the related qvw file is missing.

Explore the perform reload setting in qlikview server and publisher, showing how changes in source or private folders may fail to reflect in public documents without an enabled reload option.