Hi community,
This is more of a functional question than a technical one.
I was asked, by the customer, to do a gathering of all the KPIs present in a Qlik Sense application (more like 5 applications). The primary 'champion' on the project, the one who understood the business mostly, has left the house and a new person is in charge of leveraging Qlik Sense - but he doesn't know what is showing in the applications because we have litte documentation, the business rules are fuzzy, etc.
So, I'm currently doing an Excel file with various columns: the KPI name, formula, where does it come from (database tables and fields), and what filters are being applied on the Extraction level, as well as Model and Application's level. The functional description (business case) is being omitted in various KPIs since we don't know the business logic that derived it.
What I want to ask you is: is there a way to streamline this process? We are talking about more than 80 KPIs. The same KPI is used in various objects/applications, but with some twerks, like the time period it refers to. And not only that: one KPI can be composed of various, smaller, KPIs, and I have a line for each of those tiny KPIs. But this implies there is a lot of repetition of tables and fields,... Kinda cumbersome!
What can I be doing in a more efficient way? I just want to know some best practices regarding this type of documentation.
Many thanks in advance!
Lisa
