Hi All
I Hope your doing good!!!
I am newbie to Qlikview I started developing apps in Qlikview , I would like to develop a Qlikview Profit and loss statement for the finance department.
the data has the tables Account master, Fact, Profit and loss category for this data I would like to generate a balance sheet like the attachment.
Here Margin is difference between A2-A3 and these two are representing same group with different line numbers
Supplies is group 2 total, and it has its own line number
Payroll is the sum total of Group 3, the values in the group has their own line numbers
TotalOPP/Rates is the sum total of group 4 excluding the Resort Opp
Netprofit is the Margin-(Supplies+Payroll+TotalOpp/Rates)
I have followed the steps those are stated in the How to Create a Profit and Loss Statement in QlikView
I have taken Line number in the Interval Match , and I have prepared an excel with the fields Description and line number start and end
,calculation flag [I have taken C as is], Space flag [S as is] however I didn't get the chart.
could you please help me on this how can get this type of balance sheet.
jmc swuehl petter-s jagan hic gwassenaar tresesco
