Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.png "Former Employee"){kind=icon}
Automations allow you to set up CI/CD pipelines for your Qlik Sense apps, using the Github connector. Below we showcase various components of a CI/CD pipeline, that can be combined and extended based on your own needs.
Commit Qlik Sense app to Github
You can commit a Qlik Sense app to Github to perform versioning - allowing you to rollback to a previous version if needed - or simply to have a backup of your apps.
The following automation commits the QVF file to Github which can be used to restore the app or to recreate it in a different space, tenant or environment:
We can also commit human readable files to Github that contain all the artefacts of the app (sheets, measures, load script etc.) to allow users to compare versions (doing a "diff") in Github. Here is an example where we loop over all sheets, for each sheet we loop over all objects and we add the json representation to a variable of type "String" (text):
Note that we apply the formula "json" to each object, this will convert the actual object to a json text representation. We are also adding a line break and then we append this text to our variable. Here is the raw view that shows the formula:
Finally we are using the variable to write to a text file on Github:
Note that we have to convert the text of the variable to base64 encoding using the base64 formula. The raw view of the above field mapping is: { base64encode: { $.ObjectString } }
In a similar manner we can commit the load script in a text file on Github:
Same as before, we apply the base64 encode formula on the load script. Here is the raw view of the above field mapping: {base64encode: {$.GetLoadScript.qScript}}
See attached for a full template that commits a wide range of artefacts from a Qlik Sense app to Github.
Restore or (re)create a Qlik Sense App from Github
Here is an example that retrieves a QVF file from Github and uses that to create a Qlik Sense App in your tenant:
You can extend this automation to also update the load script if the imported Qlik Sense App. This is useful e.g. when people collaborated on the load script and merged their changes in Github:
Run tests on a Qlik Sense App on new Pull Request (PR) in Github
A common CI/CD pipeline practice is to run tests when a new pull request (PR) is opened. Here is a simple example of an automation that is triggered when a new PR is created in Github:
Note that we added a Condition block to the automation. This is needed because Github will emit an event when the PR is opened, but also e.g. when it is closed:
The automation runs a few tests on a Qlik Sense App. In our example we perform following tests:
- Reload the app and see if that succeeds
- Get a measure value from the app and check if it has the correct value
Finally, the automation adds a comment to the PR with the test results, or it can set the PR to "Approved" using the Github block "Add Pull Request Review":
