NRGAnalytics

August 6, 2026 · View on GitHub

Qlik Sense (Qlik Cloud) load scripts for Electro Market / NRG analytics apps. 1C-sourced QVDs (Russian names) → Georgian field names → per-app data models.

  • Architecture, conventions, and gotchas: see CLAUDE.md
  • Direction plans design record: see docs/direction-plans.md
  • P&L by direction design record: see docs/pl-by-direction.md — fact assembly, matching-sheet cell semantics (weight 1 / fixed fractions / დინამიურად), allocation variants, 1C-order article sorting, previous-month data cap, and the app-side vPLVariant contract
  • P&L budget (parked): see docs/pl-budget-parked.md — design decisions and reference implementation for budgeting the P&L from Google Sheets. Written and reverted 2026-07-29 pending a new sheet format; only the load block is format-specific. Raw diff kept as docs/pl-budget-v1.patch
  • P&L source query (1C): see docs/pl.txt — the original analyst query whose register+journal logic the SD 0206 script reimplements (its header comment refers to it as pl.txt). Reference only, never executed. Full 1C config dump: D:\Claude\nrg1c\src (clone of Sabissimo/nrg1c).

Scripts are grouped by app prefix (SD, Sales, Stock, Debitors, Cashflow, Credits, Accounting, Statement); each app's master .qvs includes the numbered files from lib://Holding:DataFiles. Local edits take effect only after uploading the changed .qvs files there and reloading the app.