Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Calculated columns to Profit&Loss statement

Dear all,

I should recreate a profit&loss statement made originally with Cognos (picture 2) by QlikView (picture 3).

The data comes from our finance system in csv-format, which I have used to create my data model (picture 4; field names in Finnish).

The challenge comes from creating the calculated columns seen in picture 1 (marked with a small calculator).

->Should I create them in load script or with set analysis in graph expressions? Either way, could you provide script examples?

        My first thoughts on the latter in picture 5.

    GOAL: The calculated columns should be similar objects as other values in the Tiliylataso-field (10, 20 and so forth).

   

Due to pressure from other tasks I seek something that gets the job done with minimal effort while satisfying the end users.   

   

I appreciate your thoughts on this!

Regards,

Juho Heino

1 Reply
Highlighted
Valued Contributor

Re: Calculated columns to Profit&Loss statement