What can you do with K4?
K4 allows you to leverage all the flexibility of spreadsheets inside QlikView®, Qlik Sense®, and Tableau®. Using an Excel© file as a template, keeping all the formulas and the formatting, K4 dynamically fetches data from the hosting BI platform and SQL live queries to populate the spreadsheet template.
You can, for example, use K4 to manage a simple Profit & Loss statement with amazing speed and simplicity: just build the template in Excel©, link cells to data and use it inside your BI app.
And it doesn’t stop there ... you can even enter text, dates, checkbox and drop lists in K4, saving on the fly to a SQL database!
In a very simple way, you can lock data (disable the data-entry) on a cell-by-cell basis: you can display actual data for a closed month and editable cells for planning months.
The locking logic can be as complex as you need: taking into account, for example, the current date versus the planning calendar and the current user versus the hierarchies.
You can manage a distributed planning process with multiple users entering data in a common database with full control thanks to K4 Audit Trails feature.
K4 does not come with a predefined business model, you can use it to build exactly the application you need.