Calculated columns to Profit&Loss statement

Anonymous — Tue, 27 May 2014 12:04:06 GMT

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

Re: Calculated columns to Profit&Loss statement

luciancotea — Tue, 27 May 2014 12:09:13 GMT