qlik-claude-framework

Post-load data quality validation patterns for Qlik development. Provides query templates for null rate analysis, referential integrity checks, value distribution analysis, row count validation, orphaned record detection, sparse field identification, and duplicate detection. Usable by the qa-reviewer when MCP or post-load data access is available. Also provides patterns for embedding validation checks directly into load scripts. Load when performing data quality validation or writing diagnostic scripts.

Captures existing platform patterns for brownfield Qlik projects. Provides structured templates for documenting existing app inventory, shared subroutine catalogs, naming convention maps, data connection standards, QVD storage conventions, and organizational coding standards. Used by requirements-analyst during Phase 0 context ingestion and by script-developer during Phase 4 for platform compatibility. Load when ingesting platform context or writing scripts that must integrate with existing platform conventions.

Star schema patterns, key resolution strategies, synthetic key prevention, QVD layer design, multi-app architecture patterns, source architecture consumption strategies, and associative engine behavior for Qlik Sense data modeling. Load when designing or reviewing data models.

Deployment procedures for Qlik Sense Cloud and client-managed environments. Covers app import, data connection setup, task scheduling, security configuration, and environment-specific considerations. Invoke manually with /qlik-deploy when preparing deployment artifacts or runbooks.

Set analysis syntax and patterns, aggregation functions, TOTAL qualifier usage, Aggr() patterns, conditional expressions, null handling in expressions, dollar-sign expansion, expression performance optimization, and common anti-patterns for Qlik Sense expression development. Load when writing or reviewing Qlik expressions.

Script syntax reference, QVD optimization, incremental load patterns (insert-only, insert/update, insert/update/delete, dual-timestamp for SCD2), master calendar generation, variable definitions, error handling, logging patterns, null handling patterns, diagnostic and validation patterns, subroutine integration, and platform gotchas (SET vs LET, dollar-sign expansion timing, SET variable comma limitation). Load when writing or reviewing Qlik load scripts.

Field naming, variable naming, table naming, expression naming, and file naming standards for Qlik Sense development. Includes cross-layer naming strategy for tracing field names from source through every ETL layer to UI display name. Includes prefix/suffix conventions, reserved words, and correct vs. incorrect examples. Load when writing or reviewing any Qlik artifact.

Memory optimization, script load optimization, expression calculation optimization, calculation conditions, data reduction techniques, and profiling/diagnostic approaches for Qlik Sense. Load when optimizing or reviewing performance-sensitive artifacts.

Initialize a new Qlik project with the standard directory structure, placeholder files, and CLAUDE.md configuration. Creates inputs/ and artifacts/ directories, .pipeline-state.json, and initial artifact placeholders. Invoke manually with /qlik-project-scaffold to set up a new project.

Complete QA checklist used by the qa-reviewer agent for validating Qlik development artifacts. Covers data model integrity, naming convention compliance, script quality, expression correctness, security gaps, cross-artifact consistency, blocked dependency audit, and data quality validation. Also available for manual invocation outside the pipeline via /qlik-review-checklist. Load when performing any QA review pass.

Section access patterns, row-level security, data reduction, OMIT field usage, hybrid security models, and Cloud vs. client-managed security implementation differences for Qlik Sense. Load when designing or reviewing security configurations.

Chart type selection guide, layout patterns, color and formatting standards, filter design, responsive design patterns, accessibility best practices, and reference app reverse-engineering patterns for Qlik Sense visualization design. Load when designing or reviewing visualizations and sheet layouts.

Data source profiling capability for Qlik development. When MCP connections are available, provides query templates and profiling procedures to assess source schemas, field types, cardinality, null rates, sample values, and data quality indicators. When MCP is unavailable, generates a structured Source Profile Template for manual completion. Includes source architecture classification (annotating tables with architectural role, key structure, mutability, incremental load pattern, and consumption implications). Load during requirements gathering or source profiling phases.