Skip to content

See Every App Object and Sheet Owner in Qlik SaaS — and Recover Lost Private Sheets ​

You open a published Qlik Cloud app to check what's inside it, and there is no single screen that answers a simple question: what sheets exist, who owns each one, and which are private? Worse, many Qlik developers have watched private sheets disappear for good after an app changed owner or the tenant moved to a new identity provider — with nothing in Qlik to bring them back.

Auditing sheets and owners by hand ​

In Qlik Cloud you inventory an app the slow way: click through the app overview, note which sheets are public, and read owners one at a time. Private sheets owned by someone else you cannot even see. To get a real list of objects and owners you fall back on the QRS or REST API and query app by app — a script, not a screen.

The bigger problem is recovery. When an owner leaves, or your tenant switches IdP, Qlik remaps user IDs. Private sheets tied to the old user ID become orphaned, and Qlik offers no way to restore them. There is no backup, no undo, no version history — the work is simply gone, and you often find out only when someone asks where their sheet went.


Gitoqlok brings Git version control, collaboration and change history to Qlik Sense and Power BI — right inside your browser. Try Gitoqlok Free


A versioned inventory you can restore from ​

Open a linked app and click the Gitoqlok icon: the Local Changes tab compares the app to the last commit and lists every object it contains — each sheet, master measure, variable and bookmark — with a checkbox and a details link. Click Save changes, tick App objects and commit. In the repository each sheet becomes its own file, such as objects/sheets/<id>.json, so you hold a plain, readable inventory of everything in the app instead of a click-through. The Git commit history records who committed what and when; Time Machine even splits each user's commits into swimlanes.

When a private sheet is lost after an ownership or IdP change, pick the commit that still contained it in the commit selector and click Update — the arrow next to it lets you restore App objects only, and Gitoqlok reapplies that sheet to the live app. To rebuild an entire app on a new tenant, open the hub popup and use Deploy from Git, choosing the exact commit to deploy. See Update and Roll Back for the full flow.

TIP

Commit your apps before any tenant migration or IdP switch. A single commit turns an irreversible loss of private sheets into a two-click Update.

Gitoqlok by Motio