# qlik-load-script

> Claude/Codex skill by [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars · Updated 2026-05-18

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, reviewing, or debugging Qlik load scripts, QVD operations, STORE/LOAD syntax, preceding LOAD, NullAsValue, script organization, or data quality defensive coding.

## Install

```sh
git clone https://github.com/Pupfish-LLC/qlik-agents /tmp/qlik-agents && ln -s /tmp/qlik-agents/skills/qlik-load-script ~/.claude/skills/qlik-load-script
```

## From README

Qlik Load Script Qlik script resembles SQL but is a fundamentally different language. It runs inside the Qlik associative engine, not a relational database. The most critical rule: Qlik script is NOT SQL. The single most predictable failure mode for AI-generated scripts is SQL syntax inside LOAD statements. Before writing any LOAD statement, internalize Section 1 below. Before writing any variable function, internalize Section 3. This skill covers script mechanics, QVD operations, incremental loads, null handling, error handling, diagnostics, variable patterns, master calendar, and subroutine integration. It does NOT cover naming conventions (see qlik-naming-conventions), data model design (see qlik-data-modeling), expression syntax (see qlik-expressions), or optimization strategies (see qlik-performance). Script Generation Constraints (CRITICAL) These SQL constructs do NOT exist in Qlik LOAD statements. Using them causes reload errors or silent failures.

## Links

- HTML page: https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-load-script/
- GitHub: https://github.com/Pupfish-LLC/qlik-agents
- Author: [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md)

## More from this repo

- [data-quality-validator](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/data-quality-validator/index.md) — Post-load data quality validation patterns for Qlik development.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [platform-conventions](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/platform-conventions/index.md) — Captures existing platform patterns for brownfield Qlik projects.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [qlik-cloud-mcp](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-cloud-mcp/index.md) — Capability registry for the Qlik Cloud MCP server.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars