Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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