Another sleepiness night, another Qlik Sense extension. This time its around master items.
What and why?
It is quite often that I build “definition” sheets, showing all the business logic behind the measures and dimensions in a dashboard. I encourage people to do this as a best practice. It helps the users quickly check the business logic used in various calculations. I believe this is crucial for self serviced BI space, as it serves as an index for end users to search and look for the correct measures and dimensions quickly, to be able to build their own view of the data, especially when you have a complex data model with multiple similarly named measures serving different purpose.
Usually I manage this by an inline load or by loading the data from external source (database, excel, csv etc) and display the information in the dashboard. But that means, someone has to manage that part of the process every time business logic changes.
To remove that dependency and encourage the developers to utilise the Qlik Sense master library more, I wanted to build something that can be used at ease and delivers the best user experience. I wanted to make life easier for the dashboard developers, reduce their work of updating multiple sources to explain the business logic.
Master Items Viewer
And to that end…I give you “Master Items Viewer”. This allows users to view master dimensions and master measures with tags, descriptions, expression etc. Also allows user to search the items by tags, expression or by name, helping them find the correct item quickly.
Until the next sleepless night….