Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
luciancotea
Specialist
Specialist