Financial Reporting Extension

[Kongson]

Topic

Financial reports is actually a table with specific format. And each of the line is calculated from some accounts with some specific attribute filters. In QlikView, the frontend requirement is able to be achieved by customizing the straight table. And backend, it is also able to be achieved by associating the right amount to each of the reporting line. However, in Qlik Sense, because of its simplicity, it is no longer available. It is impossible to customize the table like cell border, font bold, font size, etc. While the world is migrating QlikView to Qlik Sense, it is still necessary for financial reporting.

Therefore, the only way to achieve this is to make use an extension to allow the reporting customization. The backend is still can still be the same to make use of the association.

Financial Reporting

Very Simple Sample

Settings Sample 1

Settings Sample 2

Keep Connected

Drop me a message for discussion and sharing if you find this interesting and useful.

[karthiccr]

Use PNL table from Qlik Visualization bundle. Check out the Vizlib finance Table.

You can try using interval match technique in the data model to map set of accounts to heads.