# Sheets Comparator

Suppose you are User A and your colleague is User B.

As User A, you should have already published your Qlik Sense app to the shared space and included User B in that shared space, specifying the actions they may undertake on the app.

Besides, you should have created a repository on the server of your choice; saved and committed the initial version of scripts and sheets, and saved it (version1 in this example).

::: info You may visit pages on [how to create a git repository for your app](https://docs.gitoqlok.com/tutorials/gitoqlok-helper/broken-reference) and [how to share Load Script and Sheets with your community.](https://docs.gitoqlok.com/tutorials/gitoqlok-helper/broken-reference) :::

Make sure you have added User B as a collaborator for your git repository.

::: info Please make note that this example deploys GitHub as the repository service. :::

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2F8Ga6EkBlL0nKE7KPR32p%2FScreen%20Shot%202022-10-23%20at%2023.25.11.png?alt=media&#x26;token=27c740c6-8a51-4280-a1de-8db019a16f11" alt=""><figcaption><p>Add User B as a collaborator</p></figcaption></figure>

User B makes a copy of the shared application, moves it to their private space, and works on a sheet visualization - they make some manipulations on the sheet. After, they activate Gitoqlok to create a branch in User A's existing repository and save and commit their work on their branch as a version2.

Now User A activates Gitoqlok and in the sheets menu, there is an additional tool from Gitoqlok Helper - Compare Sheets. Click on it and select the repository.

::: info You may visit the page on [how to activate Gitoqlok Helper.](https://docs.gitoqlok.com/tutorials/gitoqlok-helper) :::

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2F9qAg3TS00UAfYiMrBma4%2Fimage.png?alt=media&#x26;token=da8b8d0f-641c-4370-b07d-cd83148774e0" alt=""><figcaption><p>Select repository</p></figcaption></figure>

The Gitoqlok Helper bar is now extended - it shows you the branches and version history of each branch. Sheets Comparator highlights sheet changes: if you place your cursor on a sheet it tells you whether the sheet is new (highlighted green) or has changes (highlighted yellow). Select the sheet that has changes (Sales & Margin Analysis in this example).

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2FPwmElTzsX1EAL7qTWFSt%2Fimage.png?alt=media&#x26;token=948076ab-83f1-4ae9-b972-1bc9cc758110" alt=""><figcaption></figcaption></figure>

Changes could be observed via Time Machine or Diff viewer.

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2F9Xv4xikRPAZGC2kvDZO7%2Fimage.png?alt=media&#x26;token=7cf7d3bd-c9ce-49b1-aba2-a7886305cc7e" alt=""><figcaption></figcaption></figure>

Time Machine navigates you between the versions of your current application branch.\
This example excluded User A's changes.

::: info You may want to revisit the [Time Machine page.](https://docs.gitoqlok.com/tutorials/gitoqlok-helper/time-machine) :::

Diff Viewer shows the differences in a panel view:

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2FQwANghQGoOzDqVyoD6kQ%2Fimage.png?alt=media&#x26;token=fd5e80c6-ed96-4e78-a1f0-5ac4bffbdc63" alt=""><figcaption></figcaption></figure>

Notice the sidebar of the Diff Viewer tool: here you can select other branches connected to User A's (your) repository to compare your current application with.

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2FZDqIkpocCHsclV6XEH1U%2Fimage.png?alt=media&#x26;token=241122f2-8ac7-4382-abee-0032968170fc" alt=""><figcaption><p>User B's branch</p></figcaption></figure>

There is now a toggle list to select the branch and an option to Apply Commit in order to merge Sheet Visualizations from different versions and branches into the current application.\
If you, on the other hand, select Cancel, the current application version (as it is on the left) will remain unchanged, but you can always re-open the Diff Viewer and apply the selected commit.

<figure><img src="https://4000103412-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8ZpQhYNESgGtGwV_FQ%2Fuploads%2F45Rad4reYnGRcBDesofO%2Fimage.png?alt=media&#x26;token=5a7da873-b525-4238-b4a3-3ef5744f2688" alt=""><figcaption><p>Apply Merge/ Cancel options on the right of the timeline</p></figcaption></figure>

## Alternative: video tutorial


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gitoqlok.com/tutorials/gitoqlok-helper/sheets-comparator.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
