Qlik’s analytics platform is built to transform your entire business through data management. But in order to release the full potential in the organization with Qlik, you need to make sure that all users have access to relevant applications and data-sets. This is where Klywa comes in. Klywa is the row level access extension that allows you to share applications with a user restricted content. In Klywa you define the role and responsibility of the members of your team. Members with the same role share applications but with Klywa they only have access to the data that they are entitled to. User configuration is done once and the dataset is adjusted if a user role is changed. User administration is simplified, and it is easy to distribute the responsibility in your organisation. Try Qlik + Klywa to spread and maximise the utilisation of your analysis applications!

Implementation guide

Step one: Setup access keys

The first step is to setup your hierarchies according to your company organization in Klywa Access.

Step two: Download access keys

Now you are ready to download your access keys from Klywa Access.

PS C:\WINDOWS\system32> cd C:\KlywaAccess
PS C:\KlywaAccess> .\Install.ps1
Install Klywa Access Tools PowerShell Module
  • Download access keys by using the Get-TagetAccessFiles cmdlet
  • Run Windows PowerShell
    • Enter the command below (use your parameters)
PS C:\> Get-TargetAccessFiles -ApiUrl https://access1.azurewebsites.net/api/ -Username your_username -Password your_password -FilePath C:\Download -TargetId your_targetid
Download access keys

Step three: Update your Qlik data model

  • Download the Access Key Guide
  • Add a composite key in the fact-table according to the guide
  • Add the two downloaded access keys (CSV-files) to the data model and make sure that the “GroupToKey”-table links correct to the fact-table.
  • Either use Section Access with Username connected to NTNAME or use Loop and reduce on GroupID and Loop and reduce on Username
Qlik Sense
  • Use Section Access with Username connected to NTNAME
  • Use Qlik Sense API and Custom Properties to control visibility per User